Names and IF/THENs

kbakermemphis · Newbie Joined: 29 Jun 2012 Posts: 2

Hello, first post.

I understand how to use IF ok but I don't know how to use it if the cell I am referencing is a word instead of a number. Or how to move to another row if the IF query is false and retry the formula.

I am simplifying the inventory sheet at the bar I work at and after the count of bottles is entered into a cell I want the order quantity to be calculated under the proper supplier heading. For example, I want to say on G3:

IF(A3='supplierA';print D3;IF('notsupplierA';goto next row)

That way all liquor coming from CS is is a nice column with the amount to buy and all liquor from DW is in a column.

I don't mind figuring this out on my own, I have a little code experience, but I just don't know where to look as I usually just use the spreadsheet for much easier calcs.

ozzie · Posted: Fri Jun 29, 2012 3:52 pm Post subject:

Alex3 · Newbie Joined: 26 Aug 2010 Posts: 4

Is this what you're looking for?:
=VLOOKUP("supplierA";A$3:D$12;4;0)

kbakermemphis · Newbie Joined: 29 Jun 2012 Posts: 2

That looks like the ticket Alex3. I will have to play with this a little to get what I want but I believe I can figure the rest of it out with this. Thank you so much.

Thank you as well ozzie.

keme · Posted: Tue Jul 10, 2012 2:14 am Post subject:

Depending on your data layout and the level of summation you are after, you may also make use of the data pilot.