Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Formula
Add ,0 to your formula to require an exact match, since your lookup column
(AB) isn't sorted: =VLOOKUP(A1,$AB$7:$AC24,2,0) "SpencerMC" wrote: I need to convert an alphanumeric value into a numerical score, according to the following list: P 3 1c 7 1b 9 1a 11 2c 13 2b 15 2a 17 3c 19 3b 21 3a 23 4c 25 4b 27 4a 29 5c 31 5b 33 5a 35 Something like =VLOOKUP(A1,$AB$7:$AC24,2) where AB7:AC24 is the location of the lookup table on the worksheet, A1 being where I type the value, doesn't work! This is due (I believe) to the mix of letters and numbers I need to be looked up. How can I do it? Nested IF statements are too confusing and you can only have up to seven! Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Lookup Min value | Excel Discussion (Misc queries) | |||
if v lookup formula | Excel Worksheet Functions | |||
Lookup Formula help | Excel Worksheet Functions | |||
lookup formula | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions |