View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Hudson Ken Hudson is offline
external usenet poster
 
Posts: 186
Default 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