Excel help

[Graham@Buyagift]

Hi,

I hope somebody can help...

I'm trying to lookup a value in another file, and return the 16th column. I then want to say if the result is x or y return 1 if not return 2.

=IF((VLOOKUP($I2,'[afile.xls]Sheet1'!$A$8:$Q$1000,16,FALSE)=OR("X","Y")),"1","2 ")

If I take the or statement out I can get it to work, so I think I'm nealy there...

Any help greatly appreicated!

Graham

[ianm]

The OR function needs to have the full comparison in it, so it would need to be -

=IF(OR(VLOOKUP($I2,'[afile.xls]Sheet1'!$A$8:$Q$1000,16,FALSE)="X",VLOOKUP($I2,'[afile.xls]Sheet1'!$A$8:$Q$1000,16,FALSE)="Y"),"1","2")

Think that should work

[Graham@Buyagift]

Thanks for your help Ian,

that certainly does the trick!

Graham