On Thu, 31 Jul 2008 03:00:06 -0700, Nylex
wrote:

I have a Sheet named "Report" and at the beginning it has a summary
To create the summary I use the VLOOKUP to find just the data I need but now
I want to get some data from another sheet - how do I do this

The other sheet is named "Building" and I want the total in column 3 - first
column will have "1-1110" in it - it will be in the area A3 to C200

Any help please


Try this formula:

=VLOOKUP("1-1110",Building!A3:C200,3,FALSE)

Hope this helps / Lars-Åke