Thread
:
If & Index & Match
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 12
If & Index & Match
would it be better to get the value by running it in VBA? if so, how do
you write it?
Please help :*(
wrote:
what is wrong with the below function:
=IF(I161500000,(INDEX(C10:H11,MATCH(I17,B10:B11,0 ),MATCH(I18,C5:H5,1),1))),IF(I161000000&I1615000 00,INDEX(C8:H9,MATCH(I17,B8:B9,1),MATCH(I18,C5:H5, 1),1)),IF(I16650000&I161000000,INDEX(C6:H7,MATCH (I17,B6:B7,1),MATCH(I18,C5:H5,1),1))
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]