How to Use the Lookup Function in Excel?

1. Open microsoft excel. 2. Fill details. 3. Select e1. 4. Click on data. 5. Click on data validation. 6. Select list. 7. Click on source. 8. Select a1 to a15. 9. Click on ok. 10. Click on f1. 11. Click on fx 12. Click on lookup and reference. 13. Click on lookup. 14. Click on ok. 15. Enter look up value,lookup vector,result vector. 16. Click on ok. Select value in e1 you can see value in f1.