# Find Column letter to use in a formula

#### a7n9

##### Well-known Member
Hello all,

I want to find the column letter to use in a formula. It would be clear when you look at this sheet.
Book3
ABCDEFG
1
2Fld1Fld2Fld3RowNumber52
3000
Sheet1

As you can see in B3:D3 I have a formula, which uses a row number from cell G2, but as a column letter I've manually entered it as B, C and D. Is there a way to elminiate this manual portion and write a formula, which would find the column letter too? I've many fields like these, therefore I want a formula, which I can drag.

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### Norie

##### Well-known Member
Why not try OFFSET instead of INDIRECT?

=OFFSET(Sheet2!B3,\$G\$2-ROW(),0)

One way:

#### just_jon

##### Legend
=INDEX(Sheet2!\$1:\$65536,\$G\$2,COLUMN())

You want to avoid a bunch of Indirects if you can.

EDIT to anchor the refs.

#### Oorang

##### Well-known Member

Another way
=VLOOKUP(Sheet2!A3,Sheet2!3:3,Sheet1!G2,0))

#### a7n9

##### Well-known Member
Thanks everyone.

just_jon: Very simple solution, thanks. (why didn't I think of that)
NBVC: It works, thanks. Now, I know how to find a column letter.
Norie: You're the boss, however, I didn't understand why are you substracting the current row?

#### Norie

##### Well-known Member
Because we're using OFFSET.

The formula is in row 3 so if we offset by 52 rows we end up in row 55 on the other sheet, therefore if we subtract the row number of the cell we get the required 52.

Replies
7
Views
149
Replies
0
Views
78
Replies
5
Views
179
Replies
7
Views
82
Replies
11
Views
252

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,500
Messages
5,832,072
Members
430,110
Latest member
Chyke_mxl

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back