Vlookup over multiple sheets

**garybarrow** · 10-27-2009, 06:48 PM

Wow!! I've been all over various threads and I've come to the conclusion that I'm too dense to figure out how to utilize the solutions provided.

I don't know anthing about code - and I'm an excel rookie, with that in mind... On the attached master sheet, in column G, H and I; I'd like to vlookup in A2 the serial number on each of the 5 tabs and return the appropriate dates in the appropriate columns.

Can anyone help me with this. It seems like it should be fairly easy but I've tried =if(isna(vlookup..... am I on the right track?

Any answer is appreciated and further appreciated if answers are written in rookie language. THANKS

**JBeaucaire** · 10-27-2009, 08:39 PM

1) Format columns G, H, and I as dates.

2) Add formulas
In G2:
=SUM(SUMIF(INDIRECT("'Company "&{1,2,3,4,5}&"'!A1:A200"),"="&$A2,INDIRECT("'Company "&{1,2,3,4,5}&"'!F1:F200")))

In H2:
=SUM(SUMIF(INDIRECT("'Company "&{1,2,3,4,5}&"'!A1:A200"),"="&$A2,INDIRECT("'Company "&{1,2,3,4,5}&"'!G1:G200")))

In I2:
=SUM(SUMIF(INDIRECT("'Company "&{1,2,3,4,5}&"'!A1:A200"),"="&$A2,INDIRECT("'Company "&{1,2,3,4,5}&"'!H1:H200")))

Copy those three cells down your data set.

3) Suppress the zero values
Click the Microsoft Office Button , click Excel Options, and then click the Advanced category.

Under Display options for this worksheet, select a worksheet, and then clear the Show a zero in cells that have zero value check box.

**garybarrow** · 10-28-2009, 10:34 AM

JBeaucaire, Thanks for the reply and the solution to my problem. It works great! In my example that I previously attached - I changed the names of the different worksheets and removed some of the other information that may be "sensitive". I'm going to try to take what you've provided and modify it to my needs. I've not worked with name manager before. Could I call on you again if I run into stumbling blocks???

**JBeaucaire** · 10-28-2009, 12:24 PM

We're here all the time. Post up any queries.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)