Worksheet - VLOOKUP
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHI
1
PRODUCT
SIZE (L)
BTL COSTPER OZNEGRONI
2
Beefeater1$16.67INGREDIENTQUANTITY (oz.)PRICE PER OZ.PRICE IN DRINK
3
Plymouth1$35.68
=VLOOKUP(F3,A:D,4,FALSE)
Beefeater1
4
Evan Williams0.75$13.75Campari1
5
Woodford Reserve0.75$33.99Cinzano1
6
Campari0.75$24.99
7
Carpano Antica0.375$18.99Total Cost
8
Angostura Bitters0.5$16.25Menu Price
9
Leblon1$29.99Cost %
10
Cinzano1$4.69
11
MANHATTAN
12
INGREDIENTQUANTITY (oz.)PRICE PER OZ.PRICE IN DRINK
13
Evan Williams
14
Cinzano
15
Angostura Bitters
16
17
Total Cost
18
Menu Price
19
Cost %
Loading...