| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP not working
That was it! Thanks SO MUCH!
"Niek Otten" wrote: Your cell probably was formatted as text before you applied the function wizard. Format as General AND re-enter the formula (F2, ENTER). Just re-formatting is not enough. -- Kind regards, Niek Otten Microsoft MVP - Excel "Small One" wrote in message ... |I am trying to use a VLOOKUP formula in my workbook. I finally have it down | so that when I am in the fx editor it tells me what will be the return value. | When I click finish however, the spot where my value SHOULD appear, it only | gives me the original formula. Doesn't even say N/A or 0, jut the formula. I | am wondering why, in the fx editing part for the VLOOKUP it would work | correct but not actually return anything in the workbook. | Formula is as follows: =VLOOKUP(D12,Sheet1!D36:H50,3,0) | Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup not working | Excel Worksheet Functions | |||
| Vlookup not working for me. | Excel Worksheet Functions | |||
| VLOOKUP not working??? | Excel Worksheet Functions | |||
| VLOOKUP example not working... | Excel Worksheet Functions | |||
| Vlookup no working | New Users to Excel | |||
Threaded Mode
