Excel Lookup
Excel Lookup
(OP)
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?





RE: Excel Lookup
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.