Forum Discussion

Copper Contributor

May 31, 2022

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...

excel

Formulas and Functions

Patrick2788

Silver Contributor

May 31, 2022

shaunullyett

Try this:

=VLOOKUP(C2,G$2:G$934012,1,FALSE)

shaunullyett
Copper Contributor
May 31, 2022
Thanks Patrick. I entered that syntax and copied it down beside the last column. Same results. No matches.
- Patrick2788
  Silver Contributor
  May 31, 2022
  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)
  - shaunullyett
    Copper Contributor
    May 31, 2022
    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?