Want the column index number to pull from 3 different cells and show the three numbers?
A Angel aAlegria Aug 19, 2005 #1 Want the column index number to pull from 3 different cells and show the three numbers?
A Angel aAlegria Aug 19, 2005 #3 =IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,FALSE)) 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
=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,FALSE)) 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
