=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE)) is the formula that
I am using, but i want to use columsn 2, 3, 4, 5 to bring up several prices.

"Niek Otten" wrote:

Can you be a bit more specific? What exactly are you trying to achieve? What
is your input data? What are your formulas? What results did you expect?
What did you get instead?

But in general, the answer is YES
--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Angel aAlegria" wrote in message
...
Want to know if you can have more than one number in a formula for a
column
index number.