Log In
Register
Home
New Member
February 11, 2019
Offline
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
See Answer
VIP
Trusted Members
June 25, 2016
Offline
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
Answers Post
New Member
February 11, 2019
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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.
1 Guest(s)
