# Solved VLOOKUP problem/poser providing a list

September 6, 2013 at 12:25:21
Specs: Windows 7
 Hi there,Just a random little poser regarding VLOOKUPIn Cell D2, I have a value, lets say that value is 15I have a list of values in Column E, from E2 to E32I have a list of names in Column F, from F2 to F32What I would like to happen is that all Names in Column F that have the value 15 in Column E be listed in Column H from cell H2Is this possible? I have looked in various forums but can not find what I think I require

See More: VLOOKUP problem/poser providing a list

#1
September 6, 2013 at 13:52:14
✔ Best Answer
 I think understand what you want, so try this:With your data like:``` D E F 1) 2) 15 5 alpha 3) 7 beta 4) 9 gamma 5) 12 delta 6) 15 epsilon 7) 17 zeta 8) 20 eta 9) 5 theta 10) 7 iota 11) 9 kappa 12) 12 lambda 13) 15 mu 14) 17 alpha 15) 20 beta 16) 5 gamma ```In cell H1 enter the formula:=IF(ISNA(INDEX(\$F2:\$F32,MATCH(E2,\$D\$2,0))),"",INDEX(\$F2:\$F32,MATCH(E2,\$D\$2,0)))Drag down to row 32,You should have only those names from column F that correspond to 15 in column E. See how that works for you.MIKEhttp://www.skeptic.com/

Report •

#2
September 8, 2013 at 06:06:11
 Mike, thanks for your response but I have had to go a completely different route on this due to changes in data that I have. I will keep this as a reference if the problem reappears

Report •

Related Solutions