Ken,

I like this since it is simple, but it didn't work initially. Until I found
that the lookup vector in the array had to be in Acending order.

"Ken Hudson" wrote:

Hi Ken,
One "back door" approach....
Insert a blank column D. In D1 enter the formula =A1 & B1 & C1 and copy down
all rows. Use this column as your looked up value (index).
Do the same thing for the values you want to use for the look up and use
VLOOKUP.
--
Ken Hudson


"Ken King" wrote:

I have four columns of data. The first three are the lookup indicies for the
4th column I want to use as my result. Can Lookup, Index or Match do this?
Ken