On Wednesday, August 20, 2014 7:32:47 PM UTC+5:30, tb wrote:
The syntax for VLOOKUP is as follows:

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])



Is there a way to have a dynamic "col_index_num" instead of a static

value?



For instance, in the formula:

=VLOOKUP($A15,'Sheet1'!$A:$AT,20,0)

is there a way to make the "20" a dynamic value such that if I add or

delete columns before the 20th one then the col_index_num will adjust

itself accordingly?



--

tb

Thanks tb and Claus for the question and the answer.. I was facing the same problem..!

San