Bit complex, but this works

=INDEX(B5:F150,CHOOSE(TOTALS!G5,94,95,1),CHOOSE(TO TALS!G5,1,1,5)))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"be_beaney" wrote in message
...
Thanks Bob,

Do you know how I can display contents of cells that are not in sequence?
eg
cells B99, B150, F5 etc.

Thanks again

"Bob Phillips" wrote:

=LOOKUP(TOTALS!G5,{1,2,3,4,5,6,7,8,9,10},B99:B103)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"be_beaney" wrote in message
...
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