Index and Match
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? |
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? |
All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com