Lookup to return multiple values
Hi Mike,
Sadly not. Result is #n/a. I think this may well be one of the things I'd
already tried.
I feel this should be a relatively easy nut to crack, yet I seem to be
struggling!
Lesley
"Mike H" wrote:
Maybe
=VLOOKUP(B2,Sheet1!A2:C5,2,FALSE)
Mike
"lesg46" wrote:
Hi,
I've searched all previous questions to try to work this out alone, but I've
failed to successfully adapt any of the examples in previous posts.
I have a large inventory that I would like to extract items from, in order
to further manipulate the returned data (otherwise I'd just filter it).
As follows:
A B C
Equipment Serial Location
Computer 123 Floor 1
Computer 456 Floor 2
Hole punch abc Garage
Ruler u3j Floor 1
On a separate worksheet, when I type a location in say B2, I'd like to see
a list of all the items in that particular location.
Thus:
A B
Location: Floor 1
Equipment Serial
Computer 123
Ruler u3j
I've been trying to use all variations of lookup, but appear to be barking
up the wrong tree, as I can't get it to return anything at all!
All help, as always, very gratefully received.
Thanks
Les
|