Index and Match
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
"helpme" wrote:
A1
=INDEX($C$130:$G$148,MATCH(B$82,$B$130:$B$148,0),M ATCH(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?
|