Taking a value 3 columns right

[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!

 

[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

 

[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?

 

[Pete_UK]

Have a look at my reply to your other post - use VLOOKUP to do this.

Pete

 

[Natalie]

Thanks a lot!

Have a look at my reply to your other post - use VLOOKUP to do this.

Pete

 

[Pete_UK]

You're welcome.

Pete

Thanks a lot!