Looking Up More than

[mellowe]

Hi All

Basically my problem is two fold - I need a LOOKUP formula that
populates cell O7 on Sheet 2 with same value as that on Sheet1 cell O7
IF:

the cell value Sheet1 B7:B200=Sheet2 B7:B200
AND Sheet1 C7:C200=Sheet2 C7:B200
AND Sheet1 D7200=Sheet2 D7:B200
AND Sheet1 E7:E200=Sheet2 E7:B200

Sheet 1
B C D E...... O
7 Q31 EUR 3652 23.65 settle
8 L17 GBP 2598 425.68 misc
9 N17 GBP 2598 425.68 misc

Sheet 2
B C D E...... O
7 N17 GBP 2598 50.00 0 (as '0' need validation drop down
list here for options)
8 Q31 EUR 3652 23.65 settle
9 L17 GBP 2598 425.68 misc

If all these values ARE NOT the same from Sheet 1 to Sheet 2 then cell
O7 is populated with "0", I would then want a drop down list to be
available with a list of options the user can choose from ( I have
already set up my Validation list called: Area_responsible.)

My range is B7200 ( so not sure whether i would need relative or
absolute values in my range so that the whole range is checked for
example: Sheet 1 cell B9 might be 2677 but the same value is in cell
B11 on sheet 2 )

Would VB code be better here?

Any Help with the below is very much appreciated!