Hello Everyone,
Great boards!
I have searched but I do not know how to make Vlookup return multiple values instead of just the first one it finds in the column. My data looks as follows
Apples 10
Banana 5
Apples 10
Apples 10
Banana 5
Banana 5
Apples 10
Apples 10
And I'd like to grab all the Apples values with a Vlookup or similar function but of course Vlookup will only return the first value of 10.
Thanks a lot for your help!
James
Great boards!
I have searched but I do not know how to make Vlookup return multiple values instead of just the first one it finds in the column. My data looks as follows
Apples 10
Banana 5
Apples 10
Apples 10
Banana 5
Banana 5
Apples 10
Apples 10
And I'd like to grab all the Apples values with a Vlookup or similar function but of course Vlookup will only return the first value of 10.
Thanks a lot for your help!
James