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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ps.com...
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

Another version (with no validation):

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

wrote:

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

--

Dave Peterson

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

Thank you very much for your time.

You rock!!!

On Mar 10, 6:07 pm, Dave Peterson wrote:
Another version (with no validation):

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



wrote:

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

--

Dave Peterson

"stale_dry_one" wrote
.. 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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---