Thread
:
Can VLookup function find and list multiple records?
View Single Post
#
2
Biff
Posts: n/a
Hi!
The ultra-easy way is to use a filter.
Another way:
Suppose your table is on sheet1 in the range A1:C4
In sheet2 A1 enter: Bk=Alpha
In sheet2 B1 enter this formula with the key combo of CTRL,SHIFT,ENTER:
=INDEX(Sheet1!B$2:B$4,SMALL(IF(Sheet1!$A$2:$A$4=$A $1,ROW($1:$3)),ROW(1:1)))
Copy across to C1 then down until you get #NUM! errors meaning the data has
been exhausted.
Biff
"Rich - SG" <Rich -
wrote in message
...
Dear Experts,
I've a table of data and wonder whether or not it's possible to use
Vlookup
or Hlookup to find and list multiple rows of matching records. Please see
example below:
Name Supplier Cost
Bk-Alpha ABC & Co 99.00
Bk-Beta 123 & Co 89.00
Bk-Apha XYZ & Co 95.00
From the above scenario, how do I go about to find "Bk-Alpha" and display
all matching rows, ie: show ABC & Co, XYZ & Co and so on?
I would really appreciate any kind help.
Million thanks.
Rich
Reply With Quote