Question: A B C D E F G H I J K Pricing Information for Tennis Balls 1 0 1 1 1 2 1 3 1
A
B
C
D
E
F
G
H
I
J
K
Pricing Information for Tennis Balls
Add formulas in cells highlighted in blue, and perform basic lookups to calculate & evaluate data
Requirements: quad Lookup "Unit Price", "Unit Shipping" & Shipping Discount".
Tips: Use correct rangelookup value ie TRUE vs FALSE
Formula
VLOOKUP
C
$D$:$E$
formula seems to be right but it doesnt work please help
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
