look up troubles when referencing two cells

S

smiley61799

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)
 
S

smiley61799

that tells me I have created a circular cell reference. I am very new to
look ups and honestly do not know much about them.
 
S

Sheeloo

Try
=VLOOKUP(A1&B1,Sheet3!E3:G50,3,FALSE)
with standard in A1 and mesh in B1
Also Col E in Sheet3 should be concatenation of values you are looking up in
A & B
and third col should contain the price you want...
If not then insert a column G before price and use something like
=E3&F3
and copy down and then use
=VLOOKUP(A1&B1,Sheet3!G3:H50,3,FALSE)
since original G will now be H
 
T

T. Valko

that tells me I have created a circular cell reference.

Don't enter the formula within the range E3:G50 or in the cells that contain
your lookup criteria, C9:D9. Enter it anywhere else but there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top