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.
@IF((E15>1),@XINDEX(TABLE:A8..TABLE:K27,E15,E12),"")
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:
=index($a$8:$k$27,e15,e12)

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?