Lookup - Display contents of a cell
I am trying to get Lookup to display the contents of a cell by using the
following formula:
=LOOKUP(TOTALS!G5,{1,2,3,4,5,6,7,8,9,10},{"B99","B 100","B101","B102","B103"})
However all that I can get to display is the text B99 and not the contents
of this cell.
Any suggestions?
Thanks
|