Mastering VLOOKUP with Multiple Criteria in Microsoft Excel - 3 Quick and Easy Methods

[@samirmalviya6682]

Yeah nice way of explaining thanks 😊❤

[@MyExcelOnline]

Thanks! Glad you liked it!

[@manishmaloo3695]

First like and comment

[@MyExcelOnline]

Thanks!

[@sanggarbayang1210]

Hi, how if i also need to have multiple output? Eg sales amount and cost

[@MyExcelOnline]

Good question! You could have a VLOOKUP for each one in a separate column.

[@MyExcelOnline]

There are a few things you could do. You could try IFS by itself or IFS with two separate VLOOKUPS. You could also look at XLOOKUP. If you would like specific help, you may also contact our consulting services here: www.myexcelonline.com/microsoft-excel-consulting-services/

[@user-zp5gp3tg5e]

Why we need helper column which is not used?

[@patrickschardt7724]

It was used though… as the first column of the lookup table.

[@MyExcelOnline]

We used the helper column to concatenate more than one field together so that you can look up a combination of two values in a row.