On Wednesday, May 2, 2012 1:55:27 PM UTC-5, LiziC wrote:
Hello,
I'm wondering if anyone can help me? I'm trying to use a combination of
an If equation and a VLookup across two different spreadsheets and I'm
not sure how to word the formula.

Basically, on the SZX TEST 1.0 spreadsheet, if the contents of Column C
is 'Y' then on the Column B on the SZX Delivery Note 1.0 is filled in
with the VLookup, and if Column C is blank, then Column B is also
blank.

The formula I've been trying is:
=IF('[SZX TEST 1.0.xls]MT'!$C:$C="Y","=VLOOKUP($A:$A,'[SZX SHENZEN TEST
(2).xls]MT'!$B:$AA,6,FALSE)","")

And I know the VLookUp part is right but I think I've messed up on
wording of it perhaps? To be honest Column C doesn't need to be 'Y', it
could be a number like '1' just as long as the formula works I'm not
fussed on letter/number is in Column C.

I realise I probably haven't explained it too well, but I've attached
the two spreadsheets if that helps?

Any help would be greatly appreciated!!

Many thanks,
Liz


+-------------------------------------------------------------------+
|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|
+-------------------------------------------------------------------+



--
LiziC
This tested in the source file. So,add your filename and change b4 to a25
=OFFSET($G$1,SUMPRODUCT(--($B$4:$B$40=B4)*--(($C$4:$C$40)="Y")*--(ROW($G$4:$G$40)-1)),0)