May 31 2022 01:03 PM
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 basically this is what I have :
R-PROP | R-RATE | E-PROP | E-RATE | ||||
AK006 | NSGV | AK006NSGV | AK006 | BASE | AK006BASE | #REF! | |
AL196 | NLK6 | AL196NLK6 | AK006 | BXMLDF | AK006BXMLDF | #N/A | |
AL212 | NLK6 | AL212NLK6 | AK006 | GNT | AK006GNT | #N/A | |
AL379 | NSGV | AL379NSGV | AK006 | NSGV | AK006NSGV | #N/A |
In the third column there are about 10,000 values that I want to check against the 7th column, which has over 934,000 values. I know that at least some of the 10,000 values do exist in the 7th column of data, but when I check the eight column, where the VLOOKUP is, in the row where I do know there is a match, I do not see the value from 7th column, it has the same "#N/A" value in it as all of column does.
This is the syntax I have for the formula: =VLOOKUP(C2,G$2:G$934012,7,FALSE).
What have I got wrong in the VLOOKUP parameters?
Thanks!
May 31 2022 01:19 PM
May 31 2022 01:39 PM
May 31 2022 02:01 PM
May 31 2022 02:44 PM
@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?
May 31 2022 03:11 PM
May 31 2022 04:31 PM