Forum Discussion
Help with Linking Columns
In the attached file, I modified the Column Labels in G4, H4, and K4 in the Master Sheet to CPR Expiry, Evaluation, and Card Expiry. The corresponding Column Labels in Engine 12 Sheet were also modified to conform thereto. The purpose of the modification is to make those Column Labels unique. You can further modify such Column Labels, provided you ensure they are unique.
In the Master Sheet, I added a Helper Column for Count with this formula:
=COUNTIF(L$5:L5,L5)
In the Engine 12 Sheet, I also added a Helper Column for Count with this formula:
=ROW()-2
Note that in the Engine 12 Sheet, I inserted a top row, wherein A1 returns the Sheet Name with this formula:
=RIGHT(CELL("filename",A1),
LEN(CELL("filename",A1))-
FIND("]",CELL("filename",A1)))
The formula in A3, copied down rows and across columns, in the Engine 12 Sheet is:
=IFNA(INDEX(Master!$B$5:$M$92,
MATCH($A$1&"|"&$K3,INDEX(Master!$L$5:$L$92&"|"&Master!$M$5:$M$92,0),0),
MATCH(A$2,Master!$B$4:$M$4,0)),"")
If the foregoing formula fulfills your requirements, you can do the same in the other Engine Sheets.
you are the Man! Thank You so much Sir. you have no idea how much i appreciate your time and effort! i am heading out of town for the week so when i get back ill check it out but it looks like it will work. Again, Thank You Sir Twifoo
- That is the Pipe symbol, which is located below F11 and between Plus (+) Sign and Backspace. You can enter it by typing Shift+Backslash. I'm glad the formula worked for you!
Twifoo it works perfectly! thank you so much, you are a Genius! i do have one question just out of curiosity. In your formula below what letter or symbol did you use between the " " that i made bold below?
=IFNA(INDEX(Master!$B$5:$M$92,MATCH($A$1&"|"&$K3,INDEX(Master!$L$5:$L$92&"|"&Master!$M$5:$M$92,0),0Twifoo
- Good luck! I look forward hearing from you soon.