Index and Match

[Guest]

A1
=INDEX($C$130:$G$148,MATCH(B$82,$B$130:$B$148,0),MATCH(I$55,$C$129:$G$129,0))

This works perfectly if cell B82 is a number (eg. 69.9%) and I55 is a
formula. However, I need cell B82 to be a formula. If I change B82 to any
formula then cell A1 shows N/A. The result of the formula in B82 shows a
result that is valid in my table. Why do I get N/A in cell A1?

 

[Guest]

Perhaps the result of the formula in B82 has trailing decimal values, causing
it to not exactly match a value in your table.

Example:
Your table may include the value 1.33

B82 may be =4/3
Formatted to only show 2 decimal places, the result would *look like* 1.33,
but it would actually be 1.333333333..... Consequently, no match.

If that's the case, try applying the round function to B82

Does that help?
***********
Regards,
Ron

XL2002, WinXP-Pro