View Full Version : Solved: VLOOKUP accross sheets

06-16-2010, 12:13 PM
I have two sheets with data I'm trying to compare.


ComID ComName ... more data

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.

06-17-2010, 07:36 AM
read up on this last night and figured out my problem.
I moved one of the fields to the front and it worked.