Solved

Problem with Wildcard and Vlookup combination

Posted on 2013-11-11
2
209 Views
Last Modified: 2013-11-20
Hi Guys, I am just trying out to figure why this Wildcard Vlookup does not work. Cell I542 contains a Vlaue of "52365.28, 2202088.28". In BC542, I have the formula Vlookup("*" & I542&"*",GBO,1,False). GBO is the range I am doing the lookup up on  and 2202088.28 is there, yet my formula is saying "#NA". Any ideas?
DummyRec2.xlsx
0
Comment
Question by:Justincut
2 Comments
 
LVL 33

Expert Comment

by:Rob Henson
ID: 39638552
You are telling the VLOOKUP to search a value containing all of "52365.28, 2202088.28" and allowing extra before or after but the cell that you are expecting it to find only contains the second half of the value therefore it will not find it.

Do you have the context of the WildCard the right way round?

If you were looking for "*"&2202088.28&"*" and the cell contained "52365.28, 2202088.28", the lookup should find it.

Thanks
Rob H
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 39638816
To make that work to extract the matching value, i.e. 22020288.28 try this formula

=LOOKUP(2^15,SEARCH(" "&GBO&","," "&I542&","),GBO)

regards, barry
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question