Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP merge documents, copy-paste special...
Hi, I have an equation that is getting the data from the 2nd column of a new
data workbook, after comparing a column in my workbook to the 1st column of new data book. The problem with is cannot get ISNA to work in conjunction with, so n/a's do not show. Have: =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE) gets 1st column into old doc fine, but I can not seem to use an IF in front of, to exclude a couple of items (to mention again, can't get rid of N/A..) =IF(OR(V124={"",".",".sym."}),"", does not work, hope enough info.. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP merge documents, copy-paste special...
Just use
=IF(ISNA(lookup_formula),"",lookup_formula) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nastech" wrote in message ... Hi, I have an equation that is getting the data from the 2nd column of a new data workbook, after comparing a column in my workbook to the 1st column of new data book. The problem with is cannot get ISNA to work in conjunction with, so n/a's do not show. Have: =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE) gets 1st column into old doc fine, but I can not seem to use an IF in front of, to exclude a couple of items (to mention again, can't get rid of N/A..) =IF(OR(V124={"",".",".sym."}),"", does not work, hope enough info.. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP merge documents, copy-paste special...
You could also use
=IF(V124={"",".",".sym."},"",VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FAL SE) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nastech" wrote in message ... Hi, I have an equation that is getting the data from the 2nd column of a new data workbook, after comparing a column in my workbook to the 1st column of new data book. The problem with is cannot get ISNA to work in conjunction with, so n/a's do not show. Have: =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE) gets 1st column into old doc fine, but I can not seem to use an IF in front of, to exclude a couple of items (to mention again, can't get rid of N/A..) =IF(OR(V124={"",".",".sym."}),"", does not work, hope enough info.. thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP merge documents, copy-paste special...
thankyou!! is there a name for the fault that produces, using 2 If Not's I
guesse.. thanks "Bob Phillips" wrote: Just use =IF(ISNA(lookup_formula),"",lookup_formula) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nastech" wrote in message ... Hi, I have an equation that is getting the data from the 2nd column of a new data workbook, after comparing a column in my workbook to the 1st column of new data book. The problem with is cannot get ISNA to work in conjunction with, so n/a's do not show. Have: =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE) gets 1st column into old doc fine, but I can not seem to use an IF in front of, to exclude a couple of items (to mention again, can't get rid of N/A..) =IF(OR(V124={"",".",".sym."}),"", does not work, hope enough info.. thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP merge documents, copy-paste special...
Sorry, I don't understand the question. Can you clarify?
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nastech" wrote in message ... thankyou!! is there a name for the fault that produces, using 2 If Not's I guesse.. thanks "Bob Phillips" wrote: Just use =IF(ISNA(lookup_formula),"",lookup_formula) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nastech" wrote in message ... Hi, I have an equation that is getting the data from the 2nd column of a new data workbook, after comparing a column in my workbook to the 1st column of new data book. The problem with is cannot get ISNA to work in conjunction with, so n/a's do not show. Have: =VLOOKUP(V124,[file.xls]sheet!$A$1:$B$3355,2,FALSE) gets 1st column into old doc fine, but I can not seem to use an IF in front of, to exclude a couple of items (to mention again, can't get rid of N/A..) =IF(OR(V124={"",".",".sym."}),"", does not work, hope enough info.. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste Subtotals only. | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) |