If the information that you're "pulling" is a number, and there are no
duplicate matches, you can use Sumproduct().

With datalist in A1 to C100, where criteria 1 can be found in Column A,
and criteria 2 can be found in Column B, and you want the numeric value from
Column C returned,
enter the Column A criteria in say D1, and the Column B criteria in D2, and
try this:

=Sumproduct((A2:A100=D1)*(B2:B100=D2)*C2:C100)

On the other hand, if the data to be returned is *not* numeric,
using the same scenario, try this *array* formula:

=Index(C1:C100,Match(1,(A1:A100=D1)*(B1:B100=D2),0 ))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Carena" wrote in message
...
What I am trying to do is find a row in sheet 1 that matches my two
reference
cells and pulling the information from a specific colume for that row. All
I
have been able to find is formulas that use one reference point.