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