Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup question | Excel Worksheet Functions | |||
VLOOKUP() Question... i hope | Excel Discussion (Misc queries) | |||
Vlookup question please | Excel Worksheet Functions | |||
vlookup question please | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |