| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VLookup returns #VALUE!
Excel 2003;
The following returns #VALUE!, which interferes with =SUM =VLOOKUP(E7,'L-Ups'!$B$8:$E$23,2,FALSE) The message is:" A value used in the formula is the wrong data type" I have taken all data, multiplied by 1, copy and paste special as value into tables. I have verified that cell E7 on the "L-Ups" Sheet is a number. I'm stuck. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP using a cell calculated with NOW returns Error | Excel Worksheet Functions | |||
| Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
| When VLOOKUP returns a #N/A How can you get it to replace #N/A wi. | Excel Worksheet Functions | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
