Don't Know How to Write If Statement in Formula

[c.clavin]

Hey all, stuck on this one and its infuriating!!

I have a range (print sheet a17:a31) that can have hundreds of possible part numbers in it. On another worksheet I have all possible items (inventory sheet a2:a672) I want to have excel give me the quantity entered on the original sheet (print sheet c17:c31) spit out on column G in my master sheet.
To give you an idea of what I'd like to express, itd be like: if inventory sheet's a2 equals anything from print sheet's a17:a31, spit out the corresponding print sheet column C into the inventory sheet's column G.

I know it's kind of confusing. It is to me too!! Thanks for the help!

 

[VoG]

Soundslike a job for VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[c.clavin]

Thanks for the response. I think I have it (somewhat) working with cell a443 for now instead of a2. How do I make the column a's corresponding column c spit out into my other worksheet's column g? That's all I'm held up on now.

=IF(VLOOKUP(A443,POITEMS,1,FALSE),?????)

FYI POITEMS = range from c17:c31

 

[VoG]

Maybe like this

=VLOOKUP(A443,'print sheet'!A17:C31,3,FALSE)

 

[c.clavin]

Wow, worked like a charm! If there are more than 1 entry for a specific item number, is there anything that can be done to combine the quantities?