Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP return query
Hi
I'm sure this will be fairly easy for someone, but I'm stumped. I have a score being input into cell N24. The format is number, no decimal places. On the same sheet I also have the values (W27-W31) 99,98,97,96,20, and next to them (col X) a score 4,3,2,1,1. These 10 cells are a names range, called "PM6Table". Scores should always be above 96, so the 20 is there to give a lowest figure (I could use 1, I guess, but it doesn't affect my problem). So then I have in cell Y27, "=VLOOKUP(N24,PM6Table,2,TRUE)" Here's the problem. If I put a score of 96 in cell N24, I get the correct result = 2. If I put in 99, however, I get a return of "1" (should be 4); if I put in a score of any other number, I get "N/ A". The only return that is correctly produced is the 96 = 2. Can anyone tell me why that should be? This format is used in 5 other parts on the same sheet, and works perfectly. The formats are the same throughout the sheet, and I've checked the VBE to see if there was anything in there that might do it, but nada. Any help would be very greatly appreciated. Thanks Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query to Return Value from Seperate Worksheet | Excel Discussion (Misc queries) | |||
msquery odbc -- excel repeats query on return | Excel Discussion (Misc queries) | |||
why dose excel return invalid web query | Excel Discussion (Misc queries) | |||
Wildcard Query to return certain criteria | Excel Discussion (Misc queries) | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions |