Not sure if this is even possible but here's the scenario.

Want to change date on worksheet 1, have the lookup function find the date
match on worksheet 2 and then populate the various cells on worksheet 1 with
the corresponding data on worksheet 2.

Not sure how to return the location of the "matched" cell in the array for
my lookup on 2nd worksheet. (i.e. date match is found on sheet 2 - cell E4 -
that's what I want it to return).

If I can get that I can use it in with an offset function to return the
value of the cells I need.

Maybe I'm not using the right functions at all - any help is appreciated!