Lookup one value, return multiple values,

J

JJ

I have tried all avenues but to no availe and require assistance urgently
please.

The formula I require has to in Worksheet A :-
[B1]

lookup DATA in Worksheet A
[A1]
SP001

in worksheet B
[A] [C]
SP001 PL001 16
SP001 PL002 5
SP001 DL001 1
CR001 PL001 5
AR001 DR001 10

Search for all Text String starting with "PL" in with corresponding
values but only for SP001.

I need the values to be seperated and not summed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Values, return multiple. 4
Multiple Values 5
Scrabble Value calculation for Welsh words 0
Lookup one value, Return matching correspnding values 7
Lookup function to cell containing multiple values 3
Lookup Multiple Values 7
Returning multiple instances of the same lookup value 0
Lookup Function Referencing cells, not text values 3

Top