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.
@MyExcelOnline9 күн бұрын
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.