Forum Discussion
shaunullyett
May 31, 2022Copper Contributor
I'm having trouble with VLOOKUP - not sure the values I'm providing are correct.
I have set lists of data and I need to compare them against each other to find matches. I thought it might be easier to compare if I concatenated the two sets of data - maybe not - I'm not sure. So b...
Patrick2788
May 31, 2022Silver Contributor
- shaunullyettMay 31, 2022Copper ContributorThanks Patrick. I entered that syntax and copied it down beside the last column. Same results. No matches.
- Patrick2788May 31, 2022Silver ContributorThere could be an issue with G. Without seeing the workbook but going off experience, it's possible there are spaces before or after the IDs.
You might try:
=VLOOKUP("*"&C2&"*",G$2:G$934012,1,FALSE)- shaunullyettMay 31, 2022Copper Contributor
Patrick2788That might have been it. I got a result in the first cell of the last column after jiggering it a bit. Not, to try and make that work in the huge data set. Thanks Patrick.
Can you tell me what the significance of changing that one parameter to 1 is?