MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rewriting a Lotus formula to work in Exce 97

Posted by Wray Martin on February 21, 2001 5:33 PM

I have the following Lotus formula that I can't rewrite to work with Excel.
I want to look up a value in the table at the intersection of row value in cell E15 and column value in cell E12.

Posted by David on February 21, 2001 10:31 PM

Wray, use the index function:

Posted by Wray Martin on February 22, 2001 11:36 PM

:David, thanks for your reply. I tried to use index, but the answer comes up #REF!. Any other ideas?