Hi Hi srm6
Working on what you posted, it looked like you wanted to invert the data!
If so, that post by the poster "Claus Busch" will not work. As that is just copy the values. But if that is what you are after, =Sheet2!C2
Kevin
Quote:
Originally Posted by srm6
Thanks Kevin. This formula worked perfectly for the information I provided to you however, when I entered it into my massive spreadsheet (19804 rows) and tweaked a few things here and there to match the columns it didn't work properly. Can you explain the steps in the formula so I can see where I tweaked it incorrectly?
The formula is in my "Raw Data" sheet column A.
It is pulling information from my "Column and Sheet Names" sheet columns G, H, I.
This is the formula after I tweaked it.
=INDEX('Column and Sheet Names'!$I$2:$I$19804,MATCH(B2&C2,'Column and Sheet Names'!$G$2:$G$19804&'Column and Sheet Names'!$H$2:$H$19804,0))
|