sissy60504
New Member
- Joined
- Jul 25, 2012
- Messages
- 13
Hi all, I have reviewed several threads on vlookups, and can't seem to find a solution to my problem.
Lookup sheet contains data as follows:
0301010 10%
0301007 0%
0301015
Sheet 2 where I am performing the lookup contains data as follows:
0301005
0301010
0301007
0301015
I need to return as follows on Sheet 2:
0301005
0301010 10
0301007 0
0301015
I need to return blanks where a value is not found in the vlookup or where a blank value is found, but return a zero if a zero value is found. I have tried using the ISNA, ISERROR, and various others solutions from other vlookup threads and cannot figure out how to get this to work. Any help is appreciated.
Lookup sheet contains data as follows:
0301010 10%
0301007 0%
0301015
Sheet 2 where I am performing the lookup contains data as follows:
0301005
0301010
0301007
0301015
I need to return as follows on Sheet 2:
0301005
0301010 10
0301007 0
0301015
I need to return blanks where a value is not found in the vlookup or where a blank value is found, but return a zero if a zero value is found. I have tried using the ISNA, ISERROR, and various others solutions from other vlookup threads and cannot figure out how to get this to work. Any help is appreciated.