Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Hey gang,
I've asked a similar question in the past, but can't seem to get it to work. I've got 74 groups listed in ColumnI (4:77) In ColC I get a group number (one of the ones listed in ColumnI) depending on numbers inputted in ColumnA. What I'm looking for is a formula in ColumnD that will compare a number inputted into ColumnA and tell me if it matches one of the numbers in the group listed before it. For example: ColA ColC ColD 7 7C 17 17A What I need is for D1 (next to the 7C) to determine if A2 (#17) is part of group 7C. The groups are all listed in a table from I4:AA77. ColumnI contains the Group Name (which is 1A, 2C, 14A...etc) and Columns J:AA contain the numbers within. Thanks for your help! Matt |
Reply |
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 |