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.
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.
Last edited by Cmorgan; 09-18-2011 at 03:54 AM.
Hi Cmorgan
You can use VLOOKUP function. If you can attach a sample file, that would help to solve the problem easily
Tom
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
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
Many thanks for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks