Lookup Help

D

Daniel

I am trying to create a double look up is it possible? For example I want to
find a value from one spreadsheet which relates to a description and a date
see below.


Product 21/12/2006 10/1/2007
hat 10 15

I need to look up into the following format


hat 21/12/2006 ???
hat 10/1/2007 ???

Concatenate is not an option. Please can you help.
 
R

RichardSchollar

Hi Daniel

Assuming table of values is on Sheet2 eg A1:F100 (so Product in A1, hat
in A2, 21/12/2006 in B1, 10/1/2007 in C1 etc ie so you have a grid of
values in B2:F100) then:

=INDEX(Sheet2!$B$2:$F$100,MATCH(A1,Sheet2!$A$2$A$100,0),MATCH(B1,Sheet2!$B$1:$F$1,0))

assuming you have eg "hat" in A1 and "10/12/2006" in B1 etc.

I hope this helps!

Richard
 
Top