×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VLOOKUP's over several sheets

VLOOKUP's over several sheets

VLOOKUP's over several sheets

(OP)
I want to use the VLOOKUP function and return more than one value on one ore more different page in my spread sheet - is there. Is there a way to search an entire spreadsheet (multiple pages) and return or sum up ALL the values I am looking for?

RE: VLOOKUP's over several sheets

I'm sure there will be a lot of ways. One way may be to use a 3-d reference. Help says:

"Refer to the same cell or range on multiple sheets by using a 3-D reference

The workbook must contain more than one worksheet. For more guidelines for using 3-D references, click  .

1    Click the cell where you want to enter the function.
2    Type = (an equal sign), enter the name of the function, and then type an opening parenthesis.
3    Click the tab for the first worksheet to be referenced.
4    Hold down SHIFT and click the tab for the last worksheet to be referenced.
5    Select the cell or range of cells to be referenced.
6    Complete the formula."

Also it seems to me there should be a way to identify a range as a concatenation of multiple ranges but I don't know how to do that.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: VLOOKUP's over several sheets

VLOOKUP across multiple sheets requires the user of named ranges.....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources