J
JJ
I need help 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 DR001 10
CR001 PL001 2
Search for all Text String starting with "PL" in Worksheet B only for
SP001 in [A]
and return with values from Worksheet B [C]
16 and 5
I need the values to be seperated and not summed.
Tx. Appreciate assistance.
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 DR001 10
CR001 PL001 2
Search for all Text String starting with "PL" in Worksheet B only for
SP001 in [A]
and return with values from Worksheet B [C]
16 and 5
I need the values to be seperated and not summed.
Tx. Appreciate assistance.