yashballari
New Member
- Joined
- Apr 12, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I would like to populate the ORDER ID value in Sheet 2 using the Asset tag and look up for the Asset tag in Sheet 1 and its corresponding ORDER ID in sheet.
=VLOOKUP("*"&A2&"*",Sheet1!A$2:B$4,2,0)
No, that shouldn't be an issue. The example has multiple values in it and you can see it returning the correct values.Hello Joe,
Thank you so much for the workaround.
However, I am unable to the results are not displaying all the data.
Some Asset tags, though they are available in the data sheet but they do not show the corresponding order ID.
Why do you think? Is it because multiple Asset tags have same Order ID ?
I cannot reproduce your example. Here is my example of the situation you describe:Hi!
I have a follow up question on your proposed formula above, @Joe4. I have a similar scenario. It works fine with cells that hold multiple values. So, thanks a lot. However, in the column A, Asset Tag, I also have cells with only one value, for example:"XYZ123", only. When I run the formula against a single value cell, I get a:"#N/A"-error.
Any suggestion as to how to get around that?
Thank you very much in advance.
=VLOOKUP("*"&A2&"*",Sheet1!A$2:B$5,2,0)