Dear Excel Expert,
I been searching for Vlookup function in google for the partial text with a wild cards but it always give me the formula looking for a partial text looking up into ranges with wild cards. My question is vice versa. Example I need to Vlookup the certain text with wild card below
<tbody>
</tbody>
<tbody>
</tbody>The formula above works fine and the answer is 2
<tbody>
</tbody>
How can I express the Vlookup formula above without changing A1 into a word "Cat"
Thanks
I been searching for Vlookup function in google for the partial text with a wild cards but it always give me the formula looking for a partial text looking up into ranges with wild cards. My question is vice versa. Example I need to Vlookup the certain text with wild card below
A | B | C | D |
Dog | SmallDogOnly | 2 | |
BigCatOnly | Cat | 10 | |
<tbody>
</tbody>
Dog | =Vlookup("*" & A1 "*",Sheet1!A1:D3,4,False) |
<tbody>
</tbody>
BigCatOnly | =Vlookup(A1,Sheet1!A1:D3,4,False) |
<tbody>
</tbody>
How can I express the Vlookup formula above without changing A1 into a word "Cat"
Thanks