Sumif instead if vlookup
Sandeep Sharma (Accounts executive) (552 Points)
14 June 2021
Can we use sumif instead if vlookup where duplicate values exist in a table??
Sandeep Sharma (Accounts executive) (552 Points)
14 June 2021
yasaswi gomes
(My grammar is 💯 good I)
(7290 Points)
Replied 15 June 2021
VLOOKUP is used to retrieve data as most commonly know.
Sumif calculates addition in a data range.
one is used to retrieve data, other is used to add multiple data.
what is your purpose please?
CAclubindia
