I'm trying to write a formula that will pull data from one sheet ('NewData') into another sheet ('Totals').
I think possibly a =VLOOKUP would work.
I would like the formula to go in Col B of 'Totals'.
The formula should first look at Col A of sheet 'Totals' to find the cell's Name text.
Then it should look at sheet 'NewData', find the LAST name in Col D that matches
the name in Col A of sheet 'Totals' AND has data (numeric) in Col B.
When this match is found, Copy that data value into Col B of 'Totals'.
Any help would be appreciated!
I should add that the names (of which there are hundreds) are all sorted alphabetically
all the time and there are no gaps between names.
Bookmarks