If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
VLOOKUP Question..
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. |
#3
|
|||
|
|||
VLOOKUP Question..
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 HIS "nastech" wrote in message ... 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. |
#4
|
|||
|
|||
VLOOKUP Question..
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 HIS "nastech" wrote in message ... 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. |
#5
|
|||
|
|||
VLOOKUP Question..
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 HIS "nastech" wrote in message ... 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. |
#6
|
|||
|
|||
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 HIS "nastech" wrote in message ... 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. |
#7
|
|||
|
|||
VLOOKUP Question..
=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 |
#8
|
|||
|
|||
VLOOKUP Question..
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 |
#9
|
|||
|
|||
VLOOKUP Question..
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VLOOKUP question | Tom Weston | General Discussion | 2 | February 10th, 2006 06:44 PM |
VLOOKUP question | jspizman | Worksheet Functions | 3 | January 22nd, 2006 09:10 PM |
VLOOKUP question | LB79 | General Discussion | 5 | May 21st, 2005 07:12 PM |
vlookup question | jd | Setting up and Configuration | 1 | September 26th, 2003 06:40 AM |
vlookup question | jd | Links and Linking | 1 | September 26th, 2003 06:40 AM |