VLOOKUP function mismatch

Question

I have to match one column from another sheet column and find the respective value of it.

I have lookup value as A : B : C : E : F in string format

and I need to match it with A : B : C : D : E : F

Is there any way using wildcard I could achieve it ? By ignoring the string D in the middle.

Answer 1

Hi there

Unfortunately, it is not very clear what you want to achieve

Here is a solution to your sample data

Sheet1

On Sheet2 use the formula =VLOOKUP(LEFT(A2,18)&"shoppers"&MID(A2,18,1000),Sheet1!A:B,2,FALSE)

If this formula does not solve your problem then

In order to help you, I kindly suggest you upload a copy of the file with dummy data to Onedrive or any other cloud sharing site and post the link here, so we can check for the problems in your workbook on our side.

a)  Remove any personal/sensitive data

b) Keep the headers, table structure, and formulas as they actually are.

c) ZIP the file if contain macros, shapes, or other objects.

If you need help with how to upload the file please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

Or follow the instructions in this video

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany

Answer 2

Hi,

See if Fuzzy lookup of the Query Editor can be of any help.

Answer 3

you want to ignore "shop_wall" ?? shop_wall is there in both the strings or you mean "shoppers"

this again is not clear to me at least ... may be someone else can follow and reply

if you could give more examples and expected output , i may be able to help

you may refer the below link for some hints to use wildcards in vlookup/filter etc.

Excel formula: Partial match with VLOOKUP | Exceljet

Answer 4

Lookup Value : hsn:customers:mst:shop_wall:sessions

Need to be matched with : hsn:customers:mst:shoppers:shop_wall:sessions

I need to ignore shoppers from the strings to match and find the value.

Thanks !

Answer 5

pls can you share some more example and details...the requirement is not clear.

a screenshot of the data with rows and column headers visible and the expected output will help

in your example you say "D" is to be ignored ...

in this case it is after C : and seems to be the 13th character ..

please specify how do we determine the position of the text to be ignored ...