I need to copy data from a table into a template where both column and row
headers are the same only mixed up. If I do a vlookup, it will match one
column of data but I will have to apply the formula separately to each row
and vice versa. Here's an example of how it looks:
Table 1:
A C B D
1
2
3
4
to be copied into a template with the follwing structu
B D C A
3
4
1
2

Is there one formula to match both the row and colum data at the same time?
Thanks!