Looking up another cell

**Cmorgan** · 09-18-2011, 02:32 AM

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** · 09-18-2011, 02:40 AM

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

**Cmorgan** · 09-18-2011, 02:55 AM

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** · 09-18-2011, 03:13 AM

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