Using =INDIRECT() in a Data Validation with Multiple Column Tables

[dparteka]

I’m using the formula shown below in a list data validation in cell K2. There are three possible entries in J2, they are Employee, Customer or Supplier, each of these are individual tables that have two columns each. As it is now when I select the drop down in K2 it displays the table data in a single list from both columns. I’m looking to have the drop down only display data from the first column. See the attached workbook… thanks for looking, your help will be much appreciated.

=INDIRECT(J2)

 

[p45cal]

try:
=INDEX(INDIRECT(J2),0,1)

 

[dparteka]

Hey p45cal… works perfectly, I figured it was something like that, I was trying this =INDEX(INDIRECT(J2,1). Thank you for the education, it helps me out a lot, I’ll be able to use this in several places.