Left Lookup Help

Welcome to the forum.

Prepare a SAMPLE workbook with ALL data in one book. Make sure that it is a small SUBSET of your real data and that it has been DESENSITISED, whilst remaining properly REPRESENTATIVE of the real data. Thanks.

Not sure ...

Try this:

=INDEX('Client Instruction Pipeline'!$A$5:$A$11,MATCH(UBWO!A2,'Client Instruction Pipeline'!$C$5:$C$11,0))

try this

=+VLOOKUP(A2,CHOOSE({1,2},'Client Instruction Pipeline'!$C$5:$C$11,'Client Instruction Pipeline'!$A$5:$A$11),2,0)

i have also attached the workbook with the formula. i could be wrong, but hope this helps.

plus, i couldnt help but notice that you are using 365 and why still not utilising XLookup for left lookups. i am curious about the reason, if you have any. being a non 365 user, this could help me understand where can xlookups not be used, for future.

i am sorry i am unable to view your attachment. i tried the same formula with the attachments in post #1, and got the results. Yes, it showed N/A for every UBWO ID, except for UBWO ID 33, as it is the first smallest value in Pipeline Test.xlsx. i have attached a screenshot, hopefully you'll be able to see it, its my first time attaching a png file here.

N/A error is showing for all UBWO ID's which are not there in your source file. if you would like to see in an empty cell instead of "N/A", you may tweak the formula to:

=IFERROR(VLOOKUP(A24,CHOOSE({1,2},'[Pipeline Test.xlsx]Client Instruction Pipeline'!$C$5:$C$94,'[Pipeline Test.xlsx]Client Instruction Pipeline'!$A$5:$A$94),2,0),"")

Xlookup will help in looking up eitherways, as vlookup will only look to the right and hlookup looks only upwards. in the formula I had mentioned, I included choose function to go around the limitation of vlookup, as my office version does not have xlookup functionality.

for how to use the same, i am not sure if i am the right guy to teach you, being a non user of that function.

Hope i helped.

@david & @Abith

Attach a WORKBOOK, not an image.

Does this work:

Formula:

Please Login or Register  to view this content.

Or maybe:

Formula:

Please Login or Register  to view this content.

Possibly, however you could do that in a workbook. Your image is fuzzy and hard to read. Avoid images if at all possible, please, because some members will not be able to see them, anyway.