Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlook up and if formula
hi
im playing with a spreadsheet at the moment trying to use vlookup which i have working however, instead of when the vlookup value providing a value of n/a when false, is there a way that i can use an if statement to return a value of "0" (zero) thanks stuart |
#2
|
|||
|
|||
Hi Stuart
One way: =IF(ISERROR(Your formula),0,Your formula) -- Best Regards Leo Heuser Followup to newsgroup only please. "Stuart" skrev i en meddelelse ... hi im playing with a spreadsheet at the moment trying to use vlookup which i have working however, instead of when the vlookup value providing a value of n/a when false, is there a way that i can use an if statement to return a value of "0" (zero) thanks stuart |
#3
|
|||
|
|||
Hi Stuart,
however, instead of when the vlookup value providing a value of n/a when false, is there a way that i can use an if statement to return a value of "0" (zero) you need your formula twice, eg. =if(iserror(vlookup(a1,data,2,false)),0,vlookup(a1 ,data,2,false)) where 0 in the middle of the formula is what you want. sometimes I use "not found", "---" or just "", depending on what is usefull in the situation, 0 is fine, too. arno |
#4
|
|||
|
|||
=if(isna(vlookup formula),0,vlookup formula)
"Stuart" wrote: hi im playing with a spreadsheet at the moment trying to use vlookup which i have working however, instead of when the vlookup value providing a value of n/a when false, is there a way that i can use an if statement to return a value of "0" (zero) thanks stuart |
#5
|
|||
|
|||
thanks for everyone's help
stuart "Stuart" wrote: hi im playing with a spreadsheet at the moment trying to use vlookup which i have working however, instead of when the vlookup value providing a value of n/a when false, is there a way that i can use an if statement to return a value of "0" (zero) thanks stuart |
#6
|
|||
|
|||
You're welcome, Stuart :-)
LeoH "stuart" skrev i en meddelelse ... thanks for everyone's help stuart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |