Search row and pull column number involving seperate sheets

[Jon.R]

Hey guys, I just had a quick question regarding 2 sheets that I have.

In the one sheet (Sheet1), I have a column (A) that lists many variables:

VarA
VarB
VarC
etc...

In another sheet (Sheet2), I have a row that has has the exact same variables, but in a different order

VarC, VarA, VarB, etc...

I was wondering if I can use a formula in Sheet 1, column B to retrieve the column Letter of the matching variable in Sheet2. I was originally thinking a VLOOKUP, but got lost very quickly in how to execute it.

Any help much appreciated, Thanks!
Jon

[FDibbins]

try something like this...
=CELL("address",OFFSET(Sheet2!A1,0,MATCH(A1,Sheet2!$A$1:$C$1,0)-1))

[Pete_UK]

Assuming the variables are in Column A of Sheet1 and in Row 1 of Sheet2, you can use this in B1 of Sheet1:

=LEFT(ADDRESS(1,MATCH(A1,Sheet2!$1:$1,0),4),LEN(ADDRESS(1,MATCH(A1,Sheet2!$1:$1,0),4))-1)

Copy down to suit.

Hope this helps.

Pete

[Jon.R]

Thank You Both!

I was able to retrieve it perfectly. You have saved me a massive amount of time :-)