Re: VLOOKUP #N/A Sometimes but not always

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Probably not all C cells are numbers, although they may look like numbers.
You can test this using the USNUMBER() function and you can correct it:
Format a blank cell as Number. Enter 1. Edit>Copy. Select your C cells.
Edit, Paste Special, check Multiply. OK.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"dmbRedGetta" <dmbRedGetta@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F87CCC5-E119-428C-B267-2BE2D8FEBB85@xxxxxxxxxxxxxxxx
> Hey all,
>
> I have an assignment I'm working on for school and I have a formula using
> VLOOKUP. In the assignment, we're looking up a discount rate based on the
> customer's credit score. The credit scores are in the first column and
> the
> discount rates are in the next four columns (the region number - 109
> yields a
> column number of 2 through 5, which explains the $D22-109 part of the
> formula). Here is the formula:
>
> =ROUND(IF($C22=0,0,((VLOOKUP($C22,$A$7:$E$13,$D22-109,TRUE))*$D$16)*$E22),
> 2)
>
> I've gotten it to work using "487" instead of the $C22, so I thought maybe
> the type of data in the cell would make a difference, but that doesn't
> seem
> to change anything. All cells are numbers, so I thought it should work.
> There is no difference (that I can see) from the rows that work and the
> rows
> that don't. Any ideas would be greatly appreciated!


.

Relevant Pages

  • Re: Game
    ... In this event handler you update your game state ... Not all browsers creates a global variable pointing to the element ... assignment only need to run in IE, ... two unpicked cells until you succede (average number of tries is only ...
    (comp.lang.javascript)
  • Re: Help with Homework
    ... There were 14 students that did not do this assignment. ... You must print a sentence with the I.D. numbers of the students who did not take the test. ... Any empty cells that are found must be counted and the number of them declared in the output statement. ... Where Scores is the variable name that stores the matrix from the Excel file. ...
    (comp.soft-sys.matlab)
  • Re: Calculate
    ... in the AdventureWorks everything is working fine, ... writes in the empty cell. ... Because the main query uses the Non Empty operator all empty cells (leaf ... The assignment for a leaf-cell is it persisted ...
    (microsoft.public.sqlserver.olap)
  • Re: VLOOKUP #N/A Sometimes but not always
    ... > Probably not all C cells are numbers, although they may look like numbers. ... > Format a blank cell as Number. ... In the assignment, we're looking up a discount rate based on the ... >> customer's credit score. ...
    (microsoft.public.excel.misc)
  • RE: open / close files and display names
    ... Change the cells .Value assignment to ... and change those single quotes to double quotes (remember you're in ... That should fix the immediate problem. ...
    (microsoft.public.excel.programming)