Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A outcomes in formulas
I am using a spreadsheet with multiple sheets and using the Vlookup formula
to pull certain data from the sheets. The VLookups are working fine, but I then have to add a certain number of Vlookups together in one formula. Again, I believe they are working fine, but some of the sheets do not have the lookup field in it, so therefore return #N/A. Is there anyway i can use an IF formula or something similar, around the Vlookup formula so the #N/A would be returned as 0.00 instead and would therefore add up as normal? I thought I had it sussed, but because the #N/A is not text, it won't recognise it in the IF function. Thanks in advance for you help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula outcomes | Excel Discussion (Misc queries) | |||
if or statements to get three possible outcomes | Excel Worksheet Functions | |||
256 possible outcomes | Excel Discussion (Misc queries) | |||
best and worst outcomes | Excel Worksheet Functions | |||
IF statement with 3 possible outcomes | Excel Worksheet Functions |