Drink Recipe Spreadsheet

**Runnin L8** · 11-01-2012, 10:36 AM

Hello all,

In the following spreadsheet, I need a formula that will look for a specific drink and then multiply the included alcohols by their respective pour size.

I don't think I can accomplish this with vlookup and I've tried a few "if" functions but haven't got one to work yet.

Any help is greatly appreciated!

**Dave H9** · 11-01-2012, 11:35 AM

Please see attached.

If that helps you owe me one of those cocktails lol

Dave H

**Runnin L8** · 11-01-2012, 11:59 AM

That works! Thank you Sir.

Now I just need to understand how to replicate the formula. I think I understand it, but what do the "$" do?

**Dave H9** · 11-01-2012, 12:01 PM

$ makes the reference absolute (wont auto increment).

I just locked the heading for the column you could replace this ref with the actual text eg "Rum".

Glad to help

Dave H

**Runnin L8** · 11-01-2012, 12:24 PM

Gotcha. Thank you again!

Unfortunately we don't make the drinks, just audit them.

Not nearly as cool.

I can tell you this though... bartenders are apt to give away 25% of alcohol in a bar... so tip well and odds are you'll always end up with a couple free drinks.

**Runnin L8** · 11-02-2012, 10:49 AM

Follow up question.

How do I move the formula to the right. (ie from Teq to Rum, Gin, Vodka ect.) In the actual sheet there are about 150 different liquors, so rewritting the formula for each column would be a bear, but if I paste the formula to a different column it changes the reference points.

Thank you,

Adam

**Dave H9** · 11-02-2012, 10:57 AM

I'll take a look and get back to you.

**Dave H9** · 11-02-2012, 11:08 AM

Runnin L8,

Give the attached a try, I haven't double checked it but it should allow horizontal and vertical copying.

Dave H

**Runnin L8** · 11-02-2012, 11:18 AM

PERFECT!!!!!!!!

I can't thank you enough for the help. We've been building these sheets by manually entering the formula's. Takes forever. Just did the entire sheet in about 5 seconds.

Unbelievably helpful!