Hello everyone,

This is my first post here, and i'm urging for any help to this situation.

(Just to be clear, I can't use INDIRECT on my data validation, because the value i'm trying to find is automatically assigned from another page)

Ok, so this is the case, I have a long spreadsheet, and i'm stuck trying to create a DropDown list, from a value that i've pulled from another sheet, this value is one of many headers from a Table, now I need to create the DropDown list from that value column so I can select another value.

I'm using this formula =INDEX((Table3[Cleaning],Table3[SteelWorker],Table3[Carpinter],Table3[Electrician]),,,J6), ***take into account that this formula will be used in a DataValidation formula using a Named Formula.

But the thing is that anyway I put it, it always returns with a #VALUE error.

Any help at all will be hugely appreciated.

Thanks