vlookup with multiple resulting values

Question

I have a table array that looks like this:

My VLOOKUP formula is to check for 1 in column A and then return the corresponding B value. Is there anyway I can get all the values for 1? Currently it just returns back the last corresponding number for 1 i.e. 9 in column B.

Well it does, because in multiple cells, just filter the table on the desired criteria. in the same cell see: https://stackoverflow.com/questions/39532189/vlookup-with-multiple-criteria-returning-values-in-one-cell — Scott Craner, Nov 22 '17 at 15:24
I want all the values for 1 then 2 and so on.... the entire data set is around 2000 values — Isra Shaikh, Nov 22 '17 at 15:26
Please show what you want for your final output. Otherwise it is hard for us to answer what you want. — Scott Craner, Nov 22 '17 at 15:27
Sorry just realised a pivot table would solve my problem! thanks anyway! — Isra Shaikh, Nov 22 '17 at 15:29

score 1 · Answer 1 · answered Nov 22 '17 at 18:02

1

You can Pivot that data, or you can try INDEX and MATCH together, perhaps even an IF command with it.

answered Nov 22 '17 at 18:02

James Winthrop

33
7

vlookup with multiple resulting values

1 Answers1