Dear All,
I hope everyone is having a good day.
I had a previous question that was solved yesterday and now I'm having another issue because the table that the formula is referencing changed.
https://www.excelforum.com/excel-for...ml#post5429958
I have a sample excel file attached. In sheet named "salary" cell A2 contains an old salary and B2 contains the new salary. What it needs to find is the exact values of A2 and B2 in the other sheet named "Medical Scale" and returns the content of the Column heading (B1 to AC1) for Level and the content of the column heading (B2 to AC2) for the Grade, the value that should return is the highest value which is the new salary.
I hope anyone can assist me. Thank you in advance.
**I have reattached the correct file.
Corine
Bookmarks