Thread
:
Formula help - possible vlookup/hlookup combination with IF or oth
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_]
external usenet poster
Posts: 896
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
Reply With Quote
Jarek Kujawa[_2_]
View Public Profile
Find all posts by Jarek Kujawa[_2_]