VLOOKUP Question..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
(e-mail address removed)
 
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 said:
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
(e-mail address removed)


nastech said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
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
(e-mail address removed)


nastech said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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
(e-mail address removed)


nastech said:
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.
Click to expand...
Click to expand...
 
=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.

=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
 
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 !!
 
Back
Top