I am trying to utilize a Vlookup but I have two cells I want the table to
look up from to pull the price of an item. For one item we have a standard
price and discounted price and depending on that item and whether it is
standard will reflect the price. I will attach some sample data so you can
see what I am trying to accomplish. I appreciate any and all assistance.
A B C
discounted MESH $3.25
standard MESH $4.45
discounted CARPET STICKERS $6.15
standard CARPET STICKERS $8.20
discounted WINDOW CLING $3.00
standard WINDOW CLING $4.20

EX: I need price of standard (a) and mesh (b) which would be $4.45

my current formula is =VLOOKUP(C9&D9,Sheet3!E3:G50,3,FALSE)