Imdabaum
06-16-2010, 12:13 PM
I have two sheets with data I'm trying to compare.
Sheet1:
CPID CPName
Sheet2:
ComID ComName ... more data
Sheet3:
CPID ComID ComName ... going to pull the rest of the data from Sheet2.
The data comes from two different table, but the CPName and ComName have can be matched.
I matched the existing ComNames using VLOOKUP(Sheet2!B2,Sheet1!B2:B8011,1,FALSE)
I'm trying to pull the ComID to Sheet3 where CPName and ComName are the same and tried something similar VLOOKUP(C3,Sheet2!A2:B37795,1,FALSE)
where C3 holds the ComName and Sheet2!A(the ComID):B37795(the ComName that exists on Sheet2)
I keep getting #N/A but I know the ComID exists because the ComName wouldn't be in Sheet3 if it wasn't in sheet2. And it wouldn't be in sheet2 if it didn't have a ComID.
Sheet1:
CPID CPName
Sheet2:
ComID ComName ... more data
Sheet3:
CPID ComID ComName ... going to pull the rest of the data from Sheet2.
The data comes from two different table, but the CPName and ComName have can be matched.
I matched the existing ComNames using VLOOKUP(Sheet2!B2,Sheet1!B2:B8011,1,FALSE)
I'm trying to pull the ComID to Sheet3 where CPName and ComName are the same and tried something similar VLOOKUP(C3,Sheet2!A2:B37795,1,FALSE)
where C3 holds the ComName and Sheet2!A(the ComID):B37795(the ComName that exists on Sheet2)
I keep getting #N/A but I know the ComID exists because the ComName wouldn't be in Sheet3 if it wasn't in sheet2. And it wouldn't be in sheet2 if it didn't have a ComID.