In my excel spreadsheet I have a large data base of numbers and a summary sheet that gives me certain values from this large data base of numbers. Is there a way for excel to take a specific number from my summary sheet and do a lookup through the data table and tell me which cell this number came from?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Lookup 1
- Thread starter eit09
- Start date
-
1
- #2
Try using the Match function
Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself. For example, you might use the MATCH function to provide a value for the row_num argument of the INDEX function.
Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself. For example, you might use the MATCH function to provide a value for the row_num argument of the INDEX function.
- Status