Hi
not really sure what you're trying to do. You may give more details what
you're looking for. But as a guess try the following array formula (entered
with cTRL+sHIFT+ENTER):
=INDEX('other_sheet'!D1:D100,MATCH(('other_sheet'! A1:A100=A1)*('other_sheet'!B1:B100=A2)*('other_she et'!C1:C100=A3),0))

this searches for a match of A1:A3 in the columns A to C on a different
sheet and returns the corresponding value from column D

--
Regards
Frank Kabel
Frankfurt, Germany
"Scooterdog" schrieb im Newsbeitrag
...
Could someone please give me a simple "example" and formula
of a index match using 3 variables, if there is such a thing.
2 of the variables are in text (a1 & a3) and 1 variable (a2)
is numeric.
Thank you in advance for your time