vlookup function

[staledryone]

I need to use a vlookup to locate a date in column B, but return the
value that is 3 rows below the date and on column E so it looks like
this B1 = Date, return value is in cell E4. Can anybody help me
with this?

Thanks in advance,
staledryone

 

[Max]

One way ..

Assuming input dates made in G1 down
place in H1:
=IF(G1="","",OFFSET(INDIRECT("B"&MATCH(G1,B:B,0)),3,3))
Copy down

 

[Dave Peterson]

Another version (with no validation):

=index(e:e,match(a1,b:b,0)+3)

 

[stale_dry_one]

The 2nd option worked great. For some reason the 1st calc did not
work.

Thank you very much for your time.

You rock!!!

 

[Max]

.. For some reason the 1st calc did not work.

No reason why it shouldn't. My suggestion assumed your input dates were made
in G1 down, not in A1 down. Just amend "G1" to "A1" in the expression given,
and it'll work just fine.

---