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.

--
Biff
Microsoft Excel MVP


"smiley61799" wrote in message
...
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.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(E3:E50=C9),--(F3:F50=D9),G3:G50)

--
Biff
Microsoft Excel MVP


"smiley61799" wrote in message
...
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)