Looking up another cell

[Cmorgan]

Morning,

A simple problem I think:

I want to put the value from BF3 on the Table sheet into a cell on a different sheet.

I've tried =Lookup, but can't get the next bit right.

Thanks for any help you can give.

[SMILE]

Hi Cmorgan
You can use VLOOKUP function. If you can attach a sample file, that would help to solve the problem easily
Tom

[Cmorgan]

Thanks for the help.

On the sheet REPORT in cell R1, I want to put the value from the TABLE sheet BF3.

Cheers

(The document itself is probably a bit of a mess, and created in strange ways, as I am self-taught - and I use that term very loosely, more trial and error

[SMILE]

Hi Cmorgan
Your question is simple, if you just need the value of BF3 of TABLE, then just type in R1 of REPORT sheet like =Table!BF3
Hope that helps u

[Cmorgan]

Many thanks for this.