Simple Left Lookup

[reneresendez]

Need a quick help on a Left Lookup:

A1 = W12001
B1 = W2
C1 = W3
D1 = 1QTR
E1 = (Need Lookup Formula to return "W12001 / value in A1 or value 4 Columns to Left)

A big Thanks for anyone that help

 

[wigi]

Maybe simply in cell E1:

=A1

But I think that will be too easy

Please explain more if this is not what you needed.

 

[Taul]

I'm a bit confused, isn't it A1/A1
and the 4th cell to the left is also A1

 

[reneresendez]

My issue is that every month the the range changes to for me. Basically I need a formula that looks up to the left 4 columns.

Thanks for your quick reply

 

[Rick Rothstein]

Does this do what you want?

=INDEX(1:1,,COLUMN()-4)

 

[crusader]

Need a quick help on a Left Lookup:

A1 = W12001
B1 = W2
C1 = W3
D1 = 1QTR
E1 = (Need Lookup Formula to return "W12001 / value in A1 or value 4 Columns to Left)

A big Thanks for anyone that help

Another option:

=OFFSET(E1,,-4)