I have a spreadsheet comparing over 300 columns of data. For this purpose I have a sample spreadsheet with only 3 data sets. I'm attempting to Index and Match utilizing a data validation menu drop down box.
Each set of Data is located in 2 columns - the second containing a much needed modifier code. However, the plan names - which I'm matching are only located in the first column (centered by alignment + center across selection) so when I attempt to match the 2nd column (left) the reference cell is blank.
Is there a dynamic formula where I can match the reference column to the left of the blank cell containing the plan name where I can the drag across 300 data sets (2 columns each)?
I'm new to forum so if someone would be kind enough to instruct me how to include an attachment, I'm happy to attach the sample spreadsheet to reference.
Each set of Data is located in 2 columns - the second containing a much needed modifier code. However, the plan names - which I'm matching are only located in the first column (centered by alignment + center across selection) so when I attempt to match the 2nd column (left) the reference cell is blank.
Is there a dynamic formula where I can match the reference column to the left of the blank cell containing the plan name where I can the drag across 300 data sets (2 columns each)?
I'm new to forum so if someone would be kind enough to instruct me how to include an attachment, I'm happy to attach the sample spreadsheet to reference.