Need some help with a formula please. I have a workbook with a Sheet for each month named that month. I also have a sheet Complete List for every item on each months sheets without any figures. I need a formula that will look at each sheet and add the number next to each matching item. VLOOKUP works as long as each item on the Complete List is on each months sheets, but this is not always true. Any suggestions?
Thanks
PB
Bookmarks