Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am having problem trying to get rid of #n/a error when i don't enter a
value. Anyone that can help, i would appreachate it. here is the cells: 50mb £5.00 £5.01 100mb £10.00 £10.01 250mb £25.00 £25.01 #N/A #N/A #N/A #N/A #N/A #N/A And formulae i am using =VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE). Also if anyone know how to add a button to finish processing the deal, and print to a templete that would be brill... Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP AND N/A ERRORS | Excel Discussion (Misc queries) | |||
VLOOKUP returning errors | Excel Worksheet Functions | |||
vlookup, but ignore errors if #n/a | Excel Worksheet Functions | |||
VLookup Errors | Excel Worksheet Functions | |||
errors using Vlookup | Excel Worksheet Functions |