Hello All:
I've attached an example of the results I'm looking for from a vlookup (in the bordered area).
The left is two example columns of raw data and the left is the results.
So I'm trying to find a vlookup I can drag horizontally that will return each result of the lookup value (e.g. Mill 160).
Any help would be greatly appreciated.
If anyone has helped - Add Reputation
Why don't you use a pivot table?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
...or..
=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$3:$B$16)/($A$3:$A$16=$E4),COLUMNS($A:A))),"")
but delete the trailing space in A5.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks