0

I'm trying to use a vlookup to pull information from one sheet to another but the reference information is different. For this example I put it on one sheet to make it easier. The information is pulled from 2 different systems. I want to search Column A for the information from Column D and return the corresponding mileage in Column E. Originally I wrote a formula for the partial string I was looking for, =LEFT(D3,SEARCH(" ",D3,SEARCH(" ",D3)+1)), but only returns #N/A when entered as vlookup, =VLOOKUP(LEFT(D3,SEARCH(" ",D3,SEARCH(" ",D3)+1)),$A$2:$B$18,2,0). I also tried using * wildcard, =VLOOKUP("*"&(LEFT(D3,SEARCH(" ",D3,SEARCH(" ",D3)+1))),$A$2:$B$18,2,0) but it still returns #N/A.

enter image description here

Any help would be greatly appreciated.

Improve this question

1 Answer 1

Reset to default
1

You need 2 wildcards e.g.

=VLOOKUP("*"&LEFT(D3,SEARCH(" ",D3,SEARCH(" ",D3)+1))&"*",$A$2:$B$18,2,0)
Improve this answer
1
  • Worked perfectly, thank you!!!
    – Tina
    Commented Oct 26, 2023 at 11:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .