# EXCEL Lookup formula

-here's the problem

i have a column(E) "Order Placed" and column(F) "order Received"
if i typed in a value in Col(E) example : E(13) = 5000
the same value should appear in col(F 25), this means that the same value should appear after 12 cells in Column F

---------
another example... if col(E 20) = 2500 col(f 32) = 2500 also..

• Hi,

in cell F25
=IF(OFFSET(F25,-12,-1)="","",OFFSET(F25,-12,-1))

and drag down as you want

hope it works for you

• Thank You So Much!!!

thanks jindon... i didn't know it can be done by a formula... seems like my teacher's kinda well...dumb ( i dont know how to put it sensitively).. hehehehe... he says it can only be done in vba... thanks so much.. thanks to ROYUK also

• Quote from killerkamatis

seems like my teacher's kinda well...dumb ( i dont know how to put it sensitively).. hehehehe...

Well you know the old saying...

Quote

"Those that CAN, DO
Those that CAN'T, TEACH!"

That's why forums are great learning resources, as you are tapping the knowledge of the DOERS as opposed to PAYING the TEACHERS

:guitar: :guitar: :tongue:

• To add to Will's saying:

Those that can't teach, teach gym.

• Quote from Seti

Those that can't teach, teach gym.

RAOTFLMFHO :facepull:

• i really appreciate you guys helping out.... also, please will someone explain what jindon gave me... =IF(OFFSET(F25,-12,-1)="","",OFFSET(F25,-12,-1))

thanks again guys.

• Hi,

OK. what you got is exactly the same result as

in cell F23
=if(E12="","",E12)
simple as above!

=INDIRECT("E"&ROW()-12)
also returns the same value

Check excel help carefully and it is easy to understand.

Good Luck!
jindon

By the way, here's VBA code
Paste code in sheet module

Private Sub Worksheet_Change(ByVal Target As Range)
with target
if (.column<>5)+(.count<>1) then exit sub
.offset(12,1).value=.value
end with
end sub

• Many Many Thanks

thanks jindon.... you rock!!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!