hisdwelling
New Member
- Joined
- Apr 10, 2002
- Messages
- 16
I have a list of part #s, prices, etc. in sheet 1, and part #s and descriptions on sheet 2. I need to bring the description from the sheet 2 into the corresponding row Column C on sheet 1. I have tried numerous vlookup formulas, but they all return #n/a as if the part # does not exist on the 2nd sheet, when in fact it does.
The formula I think is right is:
=VLOOKUP(A2,Sheet2!$A$2:$B$4210,2)
where A2 = the part # I need the description for, and Sheet2 column a contains a list of part #s, and column B contains the descriptions.
I'm thinking that the problem has to do with cell formatting, but I have tried everything I know to assure that column A on each sheet share the same formatting.
Can anyone help?
The formula I think is right is:
=VLOOKUP(A2,Sheet2!$A$2:$B$4210,2)
where A2 = the part # I need the description for, and Sheet2 column a contains a list of part #s, and column B contains the descriptions.
I'm thinking that the problem has to do with cell formatting, but I have tried everything I know to assure that column A on each sheet share the same formatting.
Can anyone help?