Multiple vlookups

[pastorkc]

I have a summary sheet and I need to look at the sheets to the right and if it finds a match to return the value. But I need it to add each time it finds a match. For example I need it to look at cell b8 and then look at the sheets to the right going from January to December and look in column B of each of those sheets if it finds a match then grab the value in column G then go to the next worksheet and do the same thing and add it to the previous value. Once it has done that then move down column B to the vehicle and do the same thing.

 

[awoohaw]

@pastorkc ,
Please provide a sample of your data and an expected outcome. Mr. Excel has tool called xl2bb add in (Link below) that allow the forum to copy data from a post into their workbooks without wasting time or making typographical errors. Please help the forum help you. If you cannot use the add in, then please post your data as a table with row and column labels.

And as with any data, please anonymize your data if there is personal/proprietary information.

Thanks in advance,