Taking a value 3 columns right

N

Natalie

Hi,

I have,

A1: 1 D1: 2

How do I write the function that if say A1="1", then G1 will take
whatever value that is 3 collumns to the right of cell A1 (in this
case, "2").

Appreciate any help on this! Thanks!
 
P

Pete_UK

Enter this formula in G1:

=IF(A1=1,D1,"")

You don't specify what you want to happen if A1 is not equal to 1, so I
have assumed you want the cell to remain blank.

Hope this helps.

Pete
 
N

Natalie

Thanks Pete,

I actually have a long list of number in a column.

For example

A1:0.8 D1:2
A2:1.0 D2:3
A3:1.2 D3:8
An: xx Dn: xx

n is integer and xx is random number

If I enter in cell E1 as "1.2", I need cell G1 to display number 8.

Is that possible?
 
Top