G GODZILLA New Member Mar 14, 2011 #1 Hello, I have a match formula bringing me back the reference of the cell i need however i need this in AZ etc. Is there a function that can do this? Thnaks
Hello, I have a match formula bringing me back the reference of the cell i need however i need this in AZ etc. Is there a function that can do this? Thnaks
Luke M Excel Ninja Staff member Mar 14, 2011 #2 =LEFT(ADDRESS(1,Change_This_Number,2),FIND("$",ADDRESS(1,Change_This_Number,2))-1) Where Change_This_Number is the number that controls column reference. Note that for ease of use, you should make this a cell reference probably.
=LEFT(ADDRESS(1,Change_This_Number,2),FIND("$",ADDRESS(1,Change_This_Number,2))-1) Where Change_This_Number is the number that controls column reference. Note that for ease of use, you should make this a cell reference probably.
