Re: VLookup for multiple values!!

Tech-Archive recommends: Fix windows errors by optimizing your registry


Yeah that worked. I reversed the logic and got the unique numbers to
populate the detail ***. Then I filtered the column on the N/A and
deleted the N/A data.
Voila!!! I have the list that I need.

One drawback

eg The result I am getting is in the following format (A big print
job)
-+---A----+---B-----+
1| 16196 | L1610 |
-+---------+---------+
2| 16196 | L2659 |
-+---------+---------+
3| 16196 | B254C |
-+---------+---------+
Instead of
-+----A---+----B----+---C---+---D----+
1| 16196 | L1610 | L2659 | B254C |
-+---------+---------+--------+---------+

Where ABCD are the column numbers and 123 are the row numbers. That is
ok as long as I get the result ;)

Thanks a lot.


LanceB Wrote:
> Reverse your logic. Use the detail *** to look up the unique header
> record
> with vlookup. Sort or use a filter to make your data readable.
>
> Lance


--
navneetjn
------------------------------------------------------------------------
navneetjn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25330
View this thread: http://www.excelforum.com/showthread.php?threadid=388306

.

Quantcast