Excel Lookup 1

[eit09]

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?

 

[sdz]

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.