# Don't Know How to Write If Statement in Formula

#### c.clavin

##### New Member
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!

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### c.clavin

##### New Member
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

##### Legend
Maybe like this

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

#### c.clavin

##### New Member
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?

Replies
6
Views
60
Replies
13
Views
102
Replies
1
Views
75
Replies
3
Views
84
Replies
4
Views
60

1,109,364
Messages
5,528,265
Members
409,811
Latest member
pjwhyman

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
• VBA vlookup multiple results
Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
• Extract values for earliest/latest times
I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...