Solved: VLOOKUP accross sheets

[Imdabaum]

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.

[Imdabaum]

read up on this last night and figured out my problem.
I moved one of the fields to the front and it worked.