Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP output
Hi. I need to use an if formula
If the VLOOKUP formula in the "list" sheet doesn't find any information in the "price" sheet, I want to use an IF formula to get information from another column in the "list" sheet. But if the VLOOKUP formula cant find any information in another sheet but the output is (in swedish) #saknas! (I think it returns #N/A in english) so I cant use the IF formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP output
VLOOKUP should be ideal for that. Don't use IF.
Please post your formula and inputs. Is the lookup table sorted? -- Kind regards, Niek Otten Microsoft MVP - Excel "Freddie" wrote in message ... Hi. I need to use an if formula If the VLOOKUP formula in the "list" sheet doesn't find any information in the "price" sheet, I want to use an IF formula to get information from another column in the "list" sheet. But if the VLOOKUP formula cant find any information in another sheet but the output is (in swedish) #saknas! (I think it returns #N/A in english) so I cant use the IF formula. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP output
=IF(ISNA(first_vlookup);second_vlookup,firts_vlook up)
sorry, not Swedish HTH Bob "Freddie" wrote in message ... Hi. I need to use an if formula If the VLOOKUP formula in the "list" sheet doesn't find any information in the "price" sheet, I want to use an IF formula to get information from another column in the "list" sheet. But if the VLOOKUP formula cant find any information in another sheet but the output is (in swedish) #saknas! (I think it returns #N/A in english) so I cant use the IF formula. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP output
In English (with my USA settings):
=if(isna(vlookup(a1,sheet2!a:c,2,false)), vlookup(a1,sheet2!a:c,3,false), vlookup(a1,sheet2!a:c,2,false))) (if it's an error, then use column 3, else use column 2.) Freddie wrote: Hi. I need to use an if formula If the VLOOKUP formula in the "list" sheet doesn't find any information in the "price" sheet, I want to use an IF formula to get information from another column in the "list" sheet. But if the VLOOKUP formula cant find any information in another sheet but the output is (in swedish) #saknas! (I think it returns #N/A in english) so I cant use the IF formula. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box - How to Use Output in Vlookup | Excel Discussion (Misc queries) | |||
vlookup not giving correct output | Excel Discussion (Misc queries) | |||
vlookup not giving correct output | Excel Discussion (Misc queries) | |||
Alternative for Vlookup output of #N/A if data not found? | Excel Discussion (Misc queries) | |||
Please help with report output! | Excel Worksheet Functions |