Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Match or Index Question | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |