Unable to perform a vlookup on a partial address

[topswim]

When I perform a Vlookup on this cell address I'm receiving N/A. I used this formula for another search where I only had five characters in the cell and needed to bring back the full value from my V look up and it worked for that.

=VLOOKUP(LEFT($D41&"*",4),'VF Recon from Ron 10-6'!L:R,1,FALSE)

 

[Fluff]

Try it like

=VLOOKUP(LEFT($D41,4)&"*",'VF Recon from Ron 10-6'!L:R,1,FALSE)

 

[topswim]

Try it like

=VLOOKUP(LEFT($D41,4)&"*",'VF Recon from Ron 10-6'!L:R,1,FALSE)

Thank you again

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Fluff]

Duplicate to: Excel- Find & Replace on toolbar not finding valid value in formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.