Req.: Formula

[BJ]

Hello,

I hope if somebody can help me out with a formule:
I have 3 columns, and in this example 8 rows
Column A1:A8 are letters ( alphabetical), if I fill in a digit in B1,B2, B3
etc the results should be shown in in column C1,C, C3 etc.
So if I fill in a in cell B1 the result in C1 should be the letter in cell
A2, if I fill in the 4 in B2 the result in C2 should be the letter in cell
A4 etc.

e.g:

A B C
1 a 2 b
2 b 4 d
3 c 8 g
4 d 3 c
5 e 5 e
6 f 1 a
7 g 7 g
8 h 2 b

Any help would be appreciated

Thanks

Berry

 

[Guest]

The INDIRECT function lets you enter a cell reference as text.

=INDIRECT("A"&B1)

In this example, if you enter 3 in cell B1, the formula will evalute as =A3, and will return the value (or letter) in A3.

Good Luck,
Mark Graesser
(e-mail address removed)


----- BJ wrote: -----

Hello,

I hope if somebody can help me out with a formule:
I have 3 columns, and in this example 8 rows
Column A1:A8 are letters ( alphabetical), if I fill in a digit in B1,B2, B3
etc the results should be shown in in column C1,C, C3 etc.
So if I fill in a in cell B1 the result in C1 should be the letter in cell
A2, if I fill in the 4 in B2 the result in C2 should be the letter in cell
A4 etc.

e.g:

A B C
1 a 2 b
2 b 4 d
3 c 8 g
4 d 3 c
5 e 5 e
6 f 1 a
7 g 7 g
8 h 2 b

Any help would be appreciated

Thanks

Berry

 

[BJ]

Thanks Mark!

Works great!!

KR

Berry

The INDIRECT function lets you enter a cell reference as text.

=INDIRECT("A"&B1)

In this example, if you enter 3 in cell B1, the formula will evalute as

=A3, and will return the value (or letter) in A3.

 

[Gord Dibben]

BJ

I would first insert a column to the left of your current column A.

Enter the numbers 1 through 8(this can be expanded to include all 26 letters
of the alphabet)

In C1 enter a number from 1 to 8

In D1 enter this formula....

=IF(ISNA(VLOOKUP(C1,$A$1:$B$26,2,FALSE)),"",VLOOKUP(C1,$A$1:$B$26,2,FALSE))

Drag/copy down as far as you need.

Entering numbers in column C will produce a letter in column D.

Gord Dibben Excel MVP

 

[Ron Rosenfeld]

Hello,

I hope if somebody can help me out with a formule:
I have 3 columns, and in this example 8 rows
Column A1:A8 are letters ( alphabetical), if I fill in a digit in B1,B2, B3
etc the results should be shown in in column C1,C, C3 etc.
So if I fill in a in cell B1 the result in C1 should be the letter in cell
A2, if I fill in the 4 in B2 the result in C2 should be the letter in cell
A4 etc.

e.g:

A B C
1 a 2 b
2 b 4 d
3 c 8 g
4 d 3 c
5 e 5 e
6 f 1 a
7 g 7 g
8 h 2 b

Any help would be appreciated

Thanks

In C1 enter the formula:

=INDEX($A$1:$A$8,B1)

And copy/drag it down to C8



--ron