L

#### LiziC

I'm wondering if anyone can help me? I'm trying to use a combination o

an If equation and a VLookup across two different spreadsheets and I'

not sure how to word the formula.

Basically, on the SZX TEST 1.0 spreadsheet, if the contents of Column

is 'Y' then on the Column B on the SZX Delivery Note 1.0 is filled i

with the VLookup, and if Column C is blank, then Column B is als

blank.

The formula I've been trying is:

=IF('[SZX TEST 1.0.xls]MT'!$C:$C="Y","=VLOOKUP($A:$A,'[SZX SHENZEN TES

(2).xls]MT'!$B:$AA,6,FALSE)","")

And I know the VLookUp part is right but I think I've messed up o

wording of it perhaps? To be honest Column C doesn't need to be 'Y', i

could be a number like '1' just as long as the formula works I'm no

fussed on letter/number is in Column C.

I realise I probably haven't explained it too well, but I've attache

the two spreadsheets if that helps?

Any help would be greatly appreciated!!

Many thanks,

Li

+-------------------------------------------------------------------

|Filename: SZX TEST 1.0.zip

|Download: http://www.excelbanter.com/attachment.php?attachmentid=359

|Filename: SZX Delivery Note 1.0.zip

|Download: http://www.excelbanter.com/attachment.php?attachmentid=360

+-------------------------------------------------------------------