VLookup/Data Problem

[taniab]

So i want to Lookup "PL01053" in a table that has multiple records. However there is also a record that is "PL01053A", I don't want it to find that one,

I know the Vlookup formula will search until it finds the FIRST record that contains all that data.

how do I get it to exclude PL01053A and keep searching until it finds PL01053 please.

thanks
Tania

 

[taniab]

oh I just got it and it works! Thank you so much!

 

[Aladin Akyurek]

oh I just got it and it works! Thank you so much!

You are welcome.