VLOOKUP Question..

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.

not sure if it matters, items compared are text, and data looking for in
other sheet / different column, is text. thanks

"nastech" wrote:

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

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.

Thankyou, and was just about to reply with answer I figured out. as "data"
sits, think your answer same as / would be correct if cut-past column
searching to column "A", then place column data need in 2nd column, hence "2"
in equation:

=VLOOKUP(V2,[file.xls]a!$A$2:$B$3355,2,FALSE)

i.e. did not know what equation was doing: is compare v2 to columns A/B, A
is searched first?, then return 2nd column data,false means exact, true
requires data be sorted in ascending order...? thanks

"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.
>
>
>

correction might be:
=IF(ISNA(VLOOKUP(V2,[file.xls]a!$A$2:$B$3355,2,FALSE)),"")

and to use Copy-Paste Special-Values, to get new data where you want it.

"nastech" wrote:

> Thankyou, and was just about to reply with answer I figured out. as "data"
> sits, think your answer same as / would be correct if cut-past column
> searching to column "A", then place column data need in 2nd column, hence "2"
> in equation:
>
> =VLOOKUP(V2,[file.xls]a!$A$2:$B$3355,2,FALSE)
>
> i.e. did not know what equation was doing: is compare v2 to columns A/B, A
> is searched first?, then return 2nd column data,false means exact, true
> requires data be sorted in ascending order...? thanks
>
> "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.
> >
> >
> >

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