3 column lookup for 4th column value
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
|