M
mellowe
Hi All
Please Please help!!
I have two spreadsheets each with one data ranges (same range -
B7:O200), I need a lookup formula that copies the value in column O7 on
s/sheet1 to O7 in s/sheet2 if the values in s/sheet1 columns B7,C7 and
E7 match those in s/sheet2
The twist is this as this is a range the values in s/sheet2 could be in
different rows to that in s/sheet1 so if match was found a "0" would be
entered in col O :
Sheet1:
B C D E .... O
7 DRF09 GBP 12340 12234.90 QWE
8 PLF99 EUR 1340 2234.80 RXP
9 BNF98 GBP 10900 23939.00 PLM
Sheet2:
B C D E .... O
7 PLF99 EUR 1340 2234.80 RXP
8 MNF22 GBP 11236 1450.22 0
9 DRF09 GBP 12340 12234.90 QWE
I have tried vlookup, index, match you name it but cant find a lookup
for checking more than one criteria. PLease help!!! thnx
Please Please help!!
I have two spreadsheets each with one data ranges (same range -
B7:O200), I need a lookup formula that copies the value in column O7 on
s/sheet1 to O7 in s/sheet2 if the values in s/sheet1 columns B7,C7 and
E7 match those in s/sheet2
The twist is this as this is a range the values in s/sheet2 could be in
different rows to that in s/sheet1 so if match was found a "0" would be
entered in col O :
Sheet1:
B C D E .... O
7 DRF09 GBP 12340 12234.90 QWE
8 PLF99 EUR 1340 2234.80 RXP
9 BNF98 GBP 10900 23939.00 PLM
Sheet2:
B C D E .... O
7 PLF99 EUR 1340 2234.80 RXP
8 MNF22 GBP 11236 1450.22 0
9 DRF09 GBP 12340 12234.90 QWE
I have tried vlookup, index, match you name it but cant find a lookup
for checking more than one criteria. PLease help!!! thnx