cdn-slasher
New member
- Joined
- Jun 28, 2012
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I have some excel experts promoting what a great function the Vlookup is. But i think i must be missing something.
- having to keep the data in the table_array you are matching in the leftmost column is overly restrictive. it can force you to keep data in an illogical order (i.e. the column you are returning has to be maintained to the right of the column you are matching)
- using a column_index_no as an offset into the array also seems cumbersome. With large tables you have to count the columns and more importantly if you insert a column later-on the formula breaks.
- the syntax and logic of the sumif function appears so much better; you simply identify the column that you want to search and the column whose result you want to return.
- you don't have to count columns,
- you can order your columns any way you want and
- the formula doesn't break if you insert a column
What am i missing ? (or is the vlookup a weak cousin to the sumif)
- having to keep the data in the table_array you are matching in the leftmost column is overly restrictive. it can force you to keep data in an illogical order (i.e. the column you are returning has to be maintained to the right of the column you are matching)
- using a column_index_no as an offset into the array also seems cumbersome. With large tables you have to count the columns and more importantly if you insert a column later-on the formula breaks.
- the syntax and logic of the sumif function appears so much better; you simply identify the column that you want to search and the column whose result you want to return.
- you don't have to count columns,
- you can order your columns any way you want and
- the formula doesn't break if you insert a column
What am i missing ? (or is the vlookup a weak cousin to the sumif)