| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE message in cell
Hello. I am am looking at using a vlookup formula on a worksheet in 2007.
It is listed below. The "Rates" is the other worksheet that has the info in to look up. I am getting the #VALUE error message in the cell, whether I do the cntrl + shift + enter or not. =(VLOOKUP($Z6,Rates!C4:Q16,(ROUND(((+$X6+2+AG$2)-0.5),0))+1)) Can anyone see where I am going wrong on this formula? Thanks to anyone responding. .... John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Message box if cell is greater than less than 0 [Zero] | Excel Discussion (Misc queries) | |||
| Error Message In Cell | Excel Discussion (Misc queries) | |||
| HOw do I fix, message: Too many different cell formats? | Excel Worksheet Functions | |||
| Yellow pop-up message in cell | Excel Discussion (Misc queries) | |||
| I keep getting the message "too many different cell formats" | Excel Worksheet Functions | |||
Threaded Mode
