Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

lookup index match

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lookup / Index Match

Lookup / Index Match

ResolvedVersion 2010

Jason has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Lookup / Index Match

hi,

I am trying to create a formula which would look at the heading column, across at the date, then return the value in the top row.

For example;

Look up values:

Heading: 2
Date: 05/06/2013

Return Value: -1

Heading 0 -1 -2
1 06/09/2012 05/09/2012 04/09/2012
1 06/12/2012 05/12/2012 04/12/2012
1 07/03/2013 06/03/2013 05/03/2013
2 06/06/2013 05/06/2013 04/06/2013
2 06/09/2013 05/09/2013 04/09/2013
2 06/12/2013 05/12/2013 04/12/2013

i have been experimenting with range look ups and Index Match but i cannot find an appropriate solution.

Many thanks,

RE: Lookup / Index Match

Hi Jason

Thanks for your question.

Like you I can't see a an immediate solution to return the correct value from the row above the dates. If I think of a way I will post a reply. Sorry I can't help for now.

Regards
Doug Dunn
STL

Excel tip:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.