View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ash Ash is offline
external usenet poster
 
Posts: 3
Default Look up two values in different columns and return matching value

I am trying to create a lookup formula that looks up a value in one column
and then looks up a second value in the second column and returns the value
in the third column corresponding to the two values.

Eg,

1 3 45
1 4 56
2 2 34
2 5 67

Look up 1 in column 1 then 3 in column 2 and return 45

Please help
--
Ash :)