Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on VLOOKUP
Hi,
My lookup_values in Col F have more number of digits than that of the first column in the table_array (C$2:D$8254). How can I do a partial matching such that if a value in Col F begins with one or more values in Col C, then the corresponding value in Col D to the highest of those matching(partial) values is returned. E.g Col C Col D Col F 1 9645 0.23 964455533 2 9644 0.31 9685768961 3 964 0.21 92347556 4 96 0.40 8593646462 5 95843 0.22 9683034746 6 9583 0.14 424567899 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
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(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |