Good day,
I am wondering if anyone can assist me on how to create a formula using VlookUp,
| Trasaction Description | Balance |
| SPAN PUR POS-63388222 000 RAJB 4847xxxxxx6196 R:340898 | 40.43 |
| SPAN PUR POS-63388212 000 NCB 5888xxxxxx0221 R:570119 | 40.44 |
if i type 340898 - result is 40.43 or any part of the Transaction Description it will give exact result.
Need you guidance.
thanks in advance
Hi jowell
You can try something like
=VLOOKUP("*"&A1&"*",D1:E3,2,FALSE)
where A1 is 340898 and D1:E3 is your range. It uses * has a wildcard.
Please note that the value of A1 must be unique otherwise the formula may not work under all circumstances.
Hope this helps.
Sunny
Thank you Mr. Sunny,
Ive tried it and it works i find also other formula using concatenate
=VLOOKUP(CONCATENATE("*",A1,"*"),RANGE,2,FALSE) it might help also others.
Thank you for your assistance.
Have a great day.
Jowell
Hello,
Actually, the formula provided by Sunny and the formula having CONCATENATE is doing just the same thing. The blog article linked too below gives you a good understanding about it.
https://www.myonlinetraininghub.com/how-to-join-text-together-in-excel-using-concatenate-and
