StephenSLR
Registered User.
- Local time
- Today, 13:31
- Joined
- Oct 25, 2005
- Messages
- 48
I have a concatenated value in Column S =CONCATENATE(P5,Q5,R5,N5)
In column T I have the formula
=LOOKUP(S5,$H$124:$H$2340,$Q$124:$Q$2340)
I can see the concatenated value I want in column A
ELBWSA 234 WPB1.5Sch80_
and this appears below in the H-Q range specified in the lookup formula but in column T there is just a blank.
I suspect the lookup formula is looking for CONCATENATE(P5,Q5,R5,N5) literally.
How do I get it to look up the value instead?
s
In column T I have the formula
=LOOKUP(S5,$H$124:$H$2340,$Q$124:$Q$2340)
I can see the concatenated value I want in column A
ELBWSA 234 WPB1.5Sch80_
and this appears below in the H-Q range specified in the lookup formula but in column T there is just a blank.
I suspect the lookup formula is looking for CONCATENATE(P5,Q5,R5,N5) literally.
How do I get it to look up the value instead?
s
Last edited: