Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
i am creating a workbook to track assessment details for my classes. As part
of this workbook i am trying to use a vlookup table to convert an assessment level to a numerical value e.g. 4B converts to 4.33. My lookup function works fine apart from any level that has the letter A in it. My lookup table is as follows 3 3 4C 4 4B 4.33 4A 4.67 5C 5 5B 5.33 5A 5.67 6C 6 6B 6.33 6A 6.67 7C 7 7B 7.33 4A returns an N/A error 5A returns the value of 4A 6A returns the value of 5A Please can anyone help me resolve this issue kind regards Si |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |