It’s an array where a comma represents next cell in the same row and semicolon represents that the following data is in the next column. Using array formulas instead of helper columns saves you worksheet real estate, and the performance can be equally good if used less number of times in a workbook.Ĭonsidering the same data set as used above, here is the formula that will give you the result: VLOOKUP with Multiple Criteria – Using the CHOOSE Function So here is the non-helper column method for you. Some people may prefer to not use any helper column while using VLOOKUP with multiple criteria. Instead of having 4 columns in the table array, I could manage with only 2 columns. I did it as it makes me use less number of cells in the VLOOKUP function. In fact, if you don’t want to temper with the original data, that should be the way to go. Why did I insert the helper column between column B and C and not in the extreme left? – There is no harm in inserting the helper column to the extreme left.But if you use a separator, then even the combination would be different (D2 and D3). Note that while A2 and A3 are different and B2 and B3 are different, the combinations end up being the same. Here is a very simple example (forgive me for my lack of creativity here):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |