Lookup

  • Thread starter Thread starter Nylex
  • Start date Start date
N

Nylex

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
 
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
Click to expand...


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
 
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
 
Back
Top