=if(iserror(VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE)),"",VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE))

"JENNYC" wrote:


I spoke too soon! Here's the formula i'm trying...and it tells me the
formula contains an error...is it maybe becasue you can't do that when
using VLOOKUP? Or did i miss something?....

=if(iserror(=VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE)),"",=VLOOKUP($A$1,'[03 Mar06 Finance
DOC.xls]IS2'!$A4:$N4,2,FALSE))


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=516347