Thread: double lookup
View Single Post
  #1   Report Post  
Geir
 
Posts: n/a
Default double lookup

I have two sheets:

In Sheet 1 I have
A B C
Key 1 Key 2 Amount
12 54 12500
16 21 1255

In Sheet 2 I have

A B C
Key 1 Key 2 Amount
19 12 1255
22 99 15555


I am trying to create a formula that find if match together Coolum A in
Sheet 1 and Coolum A in Sheet 2.
I can not find any fnctions that works for me.

Thanks Geir