Hi,

Maybe...

=SUMPRODUCT((criteria1)*(criteria2)*(criteria3),ra nge to lookin)

Hope this helps!
Jean-Guy

"staticx5151" wrote:

Hello All,
I am trying to pull in a value into a spreadhseet using Vlookup. I have
figured out how to do this with one lookup value(cell), I am having trouble
trying to get this to work when there are 3 different cells I need for the
lookup value. What I am ultimately trying to do is pull a value into my
spreadsheet from a refrence sheet when the three cells match. I don't know
if vlookup is something I should be using. The criteria will always match my
refrence sheet, I just need the variable value from my refrence sheet to be
dropped in when it finds a match. I hope this makes some sense. If anyone
has any ideas how I could do this I would appreciate your help.


i.e.
Cell Criteria 1 Criteria 2 Criteria 3 =value from DB
spreadsheet
a1 ad 1 mp 1 sz 1 Variable #
a2 ad 2 mp 2 sz 2 Variable #
a3 ad 3 mp 3 sz 3 Variable #
a4 ad 4 mp 4 sz 4 Variable #