| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup errors #n/a
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
Try
=ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
Hi
It said " you have entered to many arguments for this function" at the "" point. I could email it to you to see? Thanks Richard "Sheeloo" wrote: Try =ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
Try it like this:
=IF(ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)) -- Biff Microsoft Excel MVP " m wrote in message ... Hi It said " you have entered to many arguments for this function" at the "" point. I could email it to you to see? Thanks Richard "Sheeloo" wrote: Try =ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
Hi
No its making my formulae that was working display #n/a. Richard "T. Valko" wrote: Try it like this: =IF(ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)) -- Biff Microsoft Excel MVP " m wrote in message ... Hi It said " you have entered to many arguments for this function" at the "" point. I could email it to you to see? Thanks Richard "Sheeloo" wrote: Try =ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
I don't see how that's possible.
If this works (doesn't return #N/A): =VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE) Then this will also work and will trap any #N/A errors: =IF(ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)) -- Biff Microsoft Excel MVP " m wrote in message ... Hi No its making my formulae that was working display #n/a. Richard "T. Valko" wrote: Try it like this: =IF(ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,0)) -- Biff Microsoft Excel MVP " m wrote in message ... Hi It said " you have entered to many arguments for this function" at the "" point. I could email it to you to see? Thanks Richard "Sheeloo" wrote: Try =ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
I did not put an IF around the formula I had provided...
Sorry... :-( You should use =IF(ISNA(VLOOKUP(J2,'Tariff Info'!$Q$3:$S$17,2,FALSE)),"",VLOOKUP(J2,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: Hi It said " you have entered to many arguments for this function" at the "" point. I could email it to you to see? Thanks Richard "Sheeloo" wrote: Try =ISNA(VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE),"",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) " wrote: 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup errors #n/a
Hi,
1. I know you have this working, but it looks like the 50mb stuff is in column J based on your formula, so you solution could be a little simpler: =IF(J4="",VLOOKUP(J4,'Tariff Info'!$Q$3:$S$17,2,FALSE)) 2. If you don't want to print errors but you don't mind seeing them in the spreadsheet you can choose File, Page Setup, Sheet tab and change Cell errors as to <blank. 3. If you don't want to handle errors via formulas in the spreadsheet you can apply conditional formatting to the cells to hide the display of errors. Choose Format, Cells, Formula is from the first drop down, and enter the formula =ISNA(K9) click the Format button and choose White under the Color drop down on the Font tab. -- Thanks, Shane Devenshire " wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
