having one more than one column index number
 

Want the column index number to pull from 3 different cells and show the
three numbers?

offset

Biff

"Angel aAlegria" wrote in message
...
Want the column index number to pull from 3 different cells and show the
three numbers?

=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE))
That is the formula I am using and it says to show the second column (2),
but I want it to show columns 2, 3, 4, 5, 6

"Biff" wrote:

offset

Biff

"Angel Alegria" wrote in message
...
Want the column index number to pull from 3 different cells and show the
three numbers?

=IF($C19="","",VLOOKUP($C19,INDIRECT($B19&"List"), COLUMN(B1),FALSE))

Just drag copy across to get column 3, 4, 5, and 6

If you mean that you want the results from columns 2 - 6 to all appear in
the same cell, I can't help you!

Biff

"Angel aAlegria" wrote in message
...
=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE))
That is the formula I am using and it says to show the second column (2),
but I want it to show columns 2, 3, 4, 5, 6

"Biff" wrote:

offset

Biff

"Angel Alegria" wrote in
message
...
Want the column index number to pull from 3 different cells and show
the
three numbers?