I have two spreadsheets that I am trying to use a lookup on. It's a little more than a VLookup. PTCI and TECI are the names for the workbooks.
In the example below, I have an example of what I am trying to do. The actual lookup part has been concatenated and then highlighted in blue. The orange is the tricky part. There are 7 columns (BLANK through Key Field 6) on the TECI that need to be translated into a number (Key) column on the PTCI.
It seems to be both a Vertical Lookup and a Horizontal Lookup. I need all the help I can get ASAP. Thank you in advance!!!!
Here is a mock up of data I put together to show you visually what I am trying to achieve.
I will be looking up the concatenated cells as the vlookup. Once the vlookup takes place, I need the Rows on the TECI rows to be transposed to the PTCI Column according to the POTS for Key Field Blank through 6.