View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
willemeulen[_41_] willemeulen[_41_] is offline
external usenet poster
 
Posts: 1
Default Match multiple values


I need to match 3 values as follows:

B5 match with sheet1!A3:A194
C5 match with sheet1!B3:B194
D5 match with sheet1!C3:C194

Return value from column sheet1!H3:H194


W


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105263