Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup, Index, Match every instance.
"D" "BA"
1 Military Major 1 2 Military Major 5 3 Military Major 1 4 Military Major 3 5 Military Major 8 6 Military Major 5 7 Military Major 3 8 Military Major 2 9 Military Major 7 10 Military Major 3 I need to "find", from a much longer list, Military Major,(sheet1 Column "D") , these enteries are all grouped together, 10 or less. For every instance column "BA" is 1, move the information contained in the corosponding cell in sheet1, column "X" to Sheet2, column "B". In the example above rows 1 & 3 qualify, would the information populated in Sheet1 "X" 1 & 3 necessarily need to appear in Sheet2 B1 & B3 or could it appear in B1 & B2? Hope I've explained well enough, Thanks in advance. M.A.Tyler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Index,match, vlookup? | Excel Discussion (Misc queries) | |||
Need Help with Index and Match or Vlookup | Excel Worksheet Functions | |||
Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
vlookup, match/index ???? | Excel Worksheet Functions |