View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
willemeulen[_2_] willemeulen[_2_] is offline
external usenet poster
 
Posts: 1
Default Multiple variable lookup tables


use the index function, this function will allow you to select the
lookup cells/value's and the column/row it must look for a match. It
will return the value of the intersecting cell.cgrin

Cheers


--
willemeulen
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93678