vlookup function

S

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
 
M

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
 
S

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

Max

stale_dry_one said:
.. For some reason the 1st calc did not work.
Click to expand...

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.
 
Top