View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Formula help - possible vlookup/hlookup combination with IF oroth

presuming yr data is in A1:F4

put e.g. 61 in A8 and 3 in B8

try:

=OFFSET($A$1;MATCH(A8,$A$2:$A$4,),MATCH(B8,$B$1:$F $1,))

the result should be 70

HIH