Forum Discussion
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...
There 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)
You might try:
=VLOOKUP("*"&C2&"*",G$2:G$934012,1,FALSE)
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?
- I think I found the problem Patrick. The values in the column that was set as the lookup_value, had trailing spaces. I did a trim on that column, and now I am getting matches in the last column.
Thanks again for your help Patrick. Looking forward to heard the significance of changing that index parameter to 1.- Glad you were able to resolve it. 1 is the column because your table array is only 1 column G:G. It would be 7 if you were going from A:G.