VLook-Up Blank cells in Linked Sheet

[brownt]

Hello All,
I'm trying to find the blank cells in a linked sheet using this string:
=IF(ISERROR(VLOOKUP(D1015, Sheet1!D:D, 2, 0)), "missing variable", VLOOKUP(D2, Sheet2!D:D, 2, 0))
It is sort of working...In sheet 1, I have all usernames in cell 'D'. On sheet 2, I have some usernames in cell 'D'. I'm trying to match these up to show "missing variable', but everyone is showing as missing.
Also, the numbers where the names are located on each sheet is different (as shown in the formula above). Does this make a difference?
Please can someone point me in the right direction? Any assistance would be greatly appreciated.
Thanks and have a wonderful day!
brownt

 

[VoG]

Should it be?

=IF(ISERROR(VLOOKUP(D2, Sheet2!D:D, 1, 0)), "missing variable", VLOOKUP(D2, Sheet2!D:D, 1, 0))

 

[T. Valko]

Hello All,
I'm trying to find the blank cells in a linked sheet using this string:
=IF(ISERROR(VLOOKUP(D1015, Sheet1!D:D, 2, 0)), "missing variable", VLOOKUP(D2, Sheet2!D:D, 2, 0))
It is sort of working...In sheet 1, I have all usernames in cell 'D'. On sheet 2, I have some usernames in cell 'D'. I'm trying to match these up to show "missing variable', but everyone is showing as missing.
Also, the numbers where the names are located on each sheet is different (as shown in the formula above). Does this make a difference?
Please can someone point me in the right direction? Any assistance would be greatly appreciated.
Thanks and have a wonderful day!
brownt

Your VLOOKUP is specifying the return value to come from column 2 of the table array but you only have 1 column referenced: Sheet1!D:D.

 

[brownt]

Thanks, I tried this but still I'm not getting the correct answer. I changed the column from '2' to '4', since this is the cell where the data resides. However, I know I'm not doing something right.

=IF(ISERROR(VLOOKUP(D2, Sheet1!D:D, 4, 0)), "missing variable", VLOOKUP(D1015, Sheet1!D:D, 4, 0))


=IF(ISERROR(VLOOKUP(D2, Sheet1!D:D, 4, 0)), "missing variable", VLOOKUP(D2, Sheet1!D:D, 4, 0))

Thanks for your assistance!

 

[T. Valko]

Thanks, I tried this but still I'm not getting the correct answer. I changed the column from '2' to '4', since this is the cell where the data resides. However, I know I'm not doing something right.

=IF(ISERROR(VLOOKUP(D2, Sheet1!D:D, 4, 0)), "missing variable", VLOOKUP(D1015, Sheet1!D:D, 4, 0))


=IF(ISERROR(VLOOKUP(D2, Sheet1!D:D, 4, 0)), "missing variable", VLOOKUP(D2, Sheet1!D:D, 4, 0))

Thanks for your assistance!

See if this helps...

http://contextures.com/xlFunctions02.html

 

[VoG]

Maybe like this

=IF(ISERROR(MATCH(D2,Sheet2!D:D,0)),"Missing",INDEX(Sheet2!D:D,MATCH(D2,Sheet2!D:D,0)))

 

[Jonmo1]

Is your goal just to see if the value in D2 EXISTS in Sheet2 Column D?

If so,

=ISNUMBER(MATCH(D2,Sheet2!D:D,0))

This will yield a True or False if D2 exists in sheet2 column D.

If you need it to return "missing variable" instead of False..

=IF(ISNUMBER(MATCH(D2,Sheet2!D:D,0)),D2,"missing variable")

 

[brownt]

Yes, my goal is to compare missing names (missing) in the field in sheet2. Sheet1 has everyone listed.
I'm getting some False and Trues, but some are correct, while others are not.

 

[Jonmo1]

Well, the formula doesn't lie.
If it returns false, then the value in D2 does not exist in Sheet2 column D. Period.
Understand that it's looking for EXACT matches.

You're going to have to look closely at your data.

For any returning False that you think should be True, visually inspect and compare the values on both sheets.
Check for Exact spelling
Check for Extra spaces (or other characters)
Like "Jon" vs " Jon" vs "Jon "
Notice the spaces.

 

[brownt]

Ok, you know you are exactly correct. I will check everything.
Thanks for your assistance. I will post when I find my error.

Thanks!