| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error in vlookup formula
Hi,
I use the following formula on one of my spreadsheets =VLOOKUP(C24,Input!$K$17:$R$1000,8,FALSE) but it returns a #N/A error message. I want to change the formula that it displays a 0 (zero) instead of #N/A. I thought of including an ISERROR statement but the formula keeps returning the error message. Can somebody please help? Thanks Minos |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Formula | Excel Discussion (Misc queries) | |||
| VLOOKUP result is not showing up - only the formula | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Threaded Mode
