Can I use VLOOKUP to find all instances of a number in column1 - and add all of in column3?

Hi. First time here, - just getting back into excel and I'm hoping I can achieve this without VBA! My file has two tables and I'm using VLOOKUP to propagate names from table1 'student number' col...

TEST Student Appointments Howard 2020-21.xlsx23 KB

excel

Formulas and Functions

SergeiBaklan
Aug 27, 2020
hauwii

Perhaps

=SUMIF(Table7[StudentNumber],[@StudentNumber],Table7[Length of Session])

if I understood your logic correctly
TEST Student Appointments Howard 2020-21.xlsx23 KB

SergeiBaklan

Diamond Contributor

Aug 27, 2020

hauwii

Perhaps

=SUMIF(Table7[StudentNumber],[@StudentNumber],Table7[Length of Session])

if I understood your logic correctly

TEST Student Appointments Howard 2020-21.xlsx23 KB

hauwii
Copper Contributor
Aug 27, 2020
Fantastic. That worked a treat! Thanks so much 🙂
- SergeiBaklan
  Diamond Contributor
  Aug 27, 2020
  hauwii , you are welcome

Forum Discussion

Can I use VLOOKUP to find all instances of a number in column1 - and add all of in column3?

Resources