Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I add blank space instead of 'FALSE' in VLookup?
Is this possible? Everytime I try to add in the " " formula, it returns an
error message. I do not want n/a's appearing as a result of my Vlookup formula in my workbook. Thanks |
#2
|
|||
|
|||
=IF(ISNA(lookup_formula),"",lookup_formula)
-- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Is this possible? Everytime I try to add in the " " formula, it returns an error message. I do not want n/a's appearing as a result of my Vlookup formula in my workbook. Thanks |
#3
|
|||
|
|||
Hi Bob, This doesnt seem to work- this is my lookup formula
=VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I insert this formula into the format below. Any ideas? Lynsey "Bob Phillips" wrote: =IF(ISNA(lookup_formula),"",lookup_formula) -- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Is this possible? Everytime I try to add in the " " formula, it returns an error message. I do not want n/a's appearing as a result of my Vlookup formula in my workbook. Thanks |
#4
|
|||
|
|||
Try this.......
=IF(ISNA(VLOOKUP(Data!U2,maps,2,FALSE)),"TEST",=VL OOKUP(Data!U2,maps,2,FALSE )) All on one line, watch out for email wordwrap.......... If it works then just delete the TEST from between the quotes......... Vaya con Dios, Chuck, CABGx3 "smithers2002" wrote in message ... Hi Bob, This doesnt seem to work- this is my lookup formula =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I insert this formula into the format below. Any ideas? Lynsey "Bob Phillips" wrote: =IF(ISNA(lookup_formula),"",lookup_formula) -- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Is this possible? Everytime I try to add in the " " formula, it returns an error message. I do not want n/a's appearing as a result of my Vlookup formula in my workbook. Thanks |
#5
|
|||
|
|||
maybe stupid, but strip the = from your formula being inserting in my
suggestion. -- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Hi Bob, This doesnt seem to work- this is my lookup formula =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I insert this formula into the format below. Any ideas? Lynsey "Bob Phillips" wrote: =IF(ISNA(lookup_formula),"",lookup_formula) -- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Is this possible? Everytime I try to add in the " " formula, it returns an error message. I do not want n/a's appearing as a result of my Vlookup formula in my workbook. Thanks |
#6
|
|||
|
|||
Thanks all its working now- the problem was a space I was putting in between
the two "", as you normally would in an IF stmt etc Ta for your help "Bob Phillips" wrote: maybe stupid, but strip the = from your formula being inserting in my suggestion. -- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Hi Bob, This doesnt seem to work- this is my lookup formula =VLOOKUP(Data!U2,maps,2,FALSE). It keeps saying there is an error when I insert this formula into the format below. Any ideas? Lynsey "Bob Phillips" wrote: =IF(ISNA(lookup_formula),"",lookup_formula) -- HTH RP (remove nothere from the email address if mailing direct) "smithers2002" wrote in message ... Is this possible? Everytime I try to add in the " " formula, it returns an error message. I do not want n/a's appearing as a result of my Vlookup formula in my workbook. Thanks |
#7
|
|||
|
|||
smithers2002 wrote:
Thanks all its working now- the problem was a space I was putting in between the two "", as you normally would in an IF stmt etc One wouldn't normally do that in an IF statement. Alan Beban |
#8
|
|||
|
|||
....it was to allow a blank space to be inserted if the answer to the If
statement was false.... "Alan Beban" wrote: smithers2002 wrote: Thanks all its working now- the problem was a space I was putting in between the two "", as you normally would in an IF stmt etc One wouldn't normally do that in an IF statement. Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"False" filling in the blank spaces | Excel Discussion (Misc queries) | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
link data to new workbook | Excel Discussion (Misc queries) | |||
How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |