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

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

That got further than I have - enter the formula as below and got no error
messqge - but the answer is #N/A

"Lars-Ã…ke Aspelin" wrote:

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

You will get #N/A if VLOOKUP can not find a match.
Make sure that you have no extra blanks, leading or trailing, in the
data in column A of worksheet Building, and that you have the
correct spelling of the worksheet name.

Lars-Åke

On Thu, 31 Jul 2008 05:32:01 -0700, Nylex
wrote:

That got further than I have - enter the formula as below and got no error
messqge - but the answer is #N/A

"Lars-Åke Aspelin" wrote:

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