podcast 584

[bam12]

This is question concerning podcast 584 refreshable validation

I understand how it works, but was wondering if there is a way to make a 2 column table from this refreshable list

but use the table name in a vlookup formula
if more info need let me know

 

[bam12]

Re: pdocast 584

bump

 

[MrExcel]

Sure - that should work. When you define the dynamic range in the Define Name dialog, you would change the final 1) to a 2).

Then - =VLOOKUP(A1,ServList,2,False)

Bill

 

[bam12]

What would the offset formula be for the table if in column a & B in the define name?