Query of index & match formula in MS Excel

asked 2021-11-01T14:49:42.847+00:00
KAR FUNG 21 Reputation points

Hi Sir,

I have created a formula using index and match formula as per picture & attachment. However, the answer didn't reflect the correct value. Kindly advise.

For your info, Tension and Shear reduction factors are similar as per columns F & G, therefore the formulas were similar. I have no issue with the reduction factors at columns F & G, rows 12 to 14 where data was index from table RFCS.

However, the reduction factor at cell F15 is referenced with table RFED. Cell F15 shows incorrect answers from the data and formula given. For example, 190 in cell E15 shall indicate the value 0.89 instead of 0.72 at cell F15. Kindly advise what is adjustment required that cell F15 shows 0.89.


File as per link:


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,333 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-11-01T19:11:58.967+00:00
    NSxZFrRt 231 Reputation points

    Hello @KAR FUNG in formula of cell F15, in second MATCH should you not reference ActualEdge (instead of ActualSpacing)? That would return value 0.89.

0 additional answers

Sort by: Most helpful