VLOOKUP Question..

Hi, sorry, am 1 step forward, but cannot get the following equation to not
list a N/A if the line was blank, etc. Need to have column can directly
paste over, without error messages, so far have: (but do not know how to use
ISNA? with)

=VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)

gets the company names from the 2nd column

"Nick Hodge" wrote:

> Then you need to use column A in the lookup range
>
> =IF(ISNA(VLOOKUP(V124,[file.xls]a!$A$2:$A$3355,1,0)),"dif","")
>
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "nastech" <nastech@discussions.microsoft.com> wrote in message
> news:34A68232-C6FB-442F-91DF-7B9E00C20303@microsoft.com...
> > Hi, I am trying to mirror the info from a different workbook, into work
> > column of new book. need to get data into new sheet. so far have
> > equation
> > that shows for duplicate records, but am trying to get info from different
> > column in old book:
> >
> > have:
> > =IF(ISNA(VLOOKUP(V124,[file.xls]a!$V$2:$V$3355,1,0)),"dif","")
> >
> > need to have data from column a in the file.xls thanks.
>
>
>

=if(isna(VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)),"",=VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE))

Hans

Sorry, withouth the equel sign in the middle.

=3Dif(isna(VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)),"",VLOOKUP(V=
1=AD24,[file.xls]sheet!$A$1:$B$3355,2,FALSE))


Hans

ahhh.. had that happen before, similar answer to (what do you call it?) a
double negative? guesse I call it a double-whamy twice over.. thanks !!

"flummi" wrote:

> Sorry, withouth the equel sign in the middle.
>
> =if(isna(VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE)),"",VLOOKUP(V1Â*24,[file.xls]sheet!$A$1:$B$3355,2,FALSE))
>
>
> Hans
>
>