Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
am not sure if its a vlookup issue
i have a master list having 10000 members.
members who should be in category "A" are in the second worksheet, those in category "B" are in the third worksheet. for several categoires. i have introduced a categories clounm in the master list and i need to fill in the categories based on wether a member appears in the second third or fourth worksheet. the member numbers are similar in tha master list and in the categories work sheets. is there a quick way of filling in the categories column. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
am not sure if its a vlookup issue
Since there are only 4 worksheets, how about just looking through each one:
=if(iserror(match(a1,sheet2!a:a,0)),"","Sheet2") &if(iserror(match(a1,sheet3!a:a,0)),"","Sheet3" ) &if(iserror(match(a1,sheet4!a:a,0)),"","Sheet4" ) &if(iserror(match(a1,sheet5!a:a,0)),"","Sheet5" ) If it finds a match in column A of sheet2, sheet3, ..., it'll put that value in the cell. If the name/id appears in more than one sheet, you'll get both returned. anthony wrote: i have a master list having 10000 members. members who should be in category "A" are in the second worksheet, those in category "B" are in the third worksheet. for several categoires. i have introduced a categories clounm in the master list and i need to fill in the categories based on wether a member appears in the second third or fourth worksheet. the member numbers are similar in tha master list and in the categories work sheets. is there a quick way of filling in the categories column. thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP, IF and RIGHT functions together | Excel Worksheet Functions | |||
Table array in VLOOKUP (EXcel 2003) | Excel Worksheet Functions | |||
VLOOKUP and wildcards | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |