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
Lookup one value, Return matching correspnding values 7
Lookup Values 4
Paste Values Based on Conditional Value 0
Lookup Multiple Values 7
help needed with lookup and related functions 3
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1

Top