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
|