VLOOKUP variable col_index_num

[Soltisolti]

In vlookup is it possible to have the col_index_num change based on the contents of another cell?

something like

=VLOOKUP ( lookup value , table_array , col_index_num = B6, [range_lookup]
so if B6 = 4 the col_index_num would be 4
but if B6 = 7 the col_index_num would be 7

Reason for asking is based on the number in column B is where I should take the answer from, offset by 4 or offset by 7.

Thanks solti

[Ron Coderre]

Just try it!
=VLOOKUP(lookup_value, table_array , B6, [range_lookup])

[AlKey]

Here is a nice video tutorial that will help you to understand how VLOOKUP function works

http://www.youtube.com/watch?v=-hJxIMBbmZY

[Soltisolti]

Thanks Ron, I was close but was using ,=B6 not , B6

AlKey will check out the video

solti

[arlu1201]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.