columns question

[mole999]

Not sure what a good search term would be.
I have a number of sets of data in a single range of columns. I'd like to have that data in multiple columns but treat as a VLOOKUP so C,J,O is that doable someway? by combing name ranges somehow

 

[Special-K99]

Do you mean like this?

=IFERROR(VLOOKUP(lookupvalue,C1:I1000,2,0),IFERROR(VLOOKUP(lookupvalue,J1:N1000,2,0),IFERROR(VLOOKUP(lookupvalue,O1:Z1000,2,0),"NOT FOUND ANYWHERE")))

 

[mole999]

That could be it, I want to treat as individuals but search as a effective long list I will give that a work out, thank you

 

[pgc01]

That could be it, I want to treat as individuals but search as a effective long list I will give that a work out, thank you

Hi

If you have a long list of columns, is there not some logic to it, like every 4th column, or columns that have a header starting with "MKT" or something that allows you to identify the column a part of the list?

 

[mole999]

Its basically a list of staff and the ID (some numeric, some text), trying to make sure I see all variants (two or three is not uncommon) in the data and provide one very clean output