Lookup the date associated with a given value

H

hello

Hello

I have a lookup question that seems easy but I cannot quite get it. I need
to lookup the date associated with a given value in set of rows. The dates
are in row 1 (so B1:B5 below). I would like to lookup the date of the maximum
value for the US and Europe. The values in the rows are not necessarily in
ascending order, which seems to be a requirement to use the lookup function.
Can anybody help please? Thank you very much.

1965 1966 1967 1968 1969
US 1318 1299 1316 1339 1372
Europe 1303 1287 1334 1350 1342
 
J

JE McGimpsey

Assuming the dates are in B1:F1 (not B1:B5), one way:

=INDEX(B1:F1,MATCH(MAX(B2:F2),B2:F2,FALSE))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup a value when the range contains a high - low format 3
Excel returning more than one value from a lookup table that match the same value 3
lookup value and date from a list with restrictions 7
lookup value from a table based on two conditions 3
return the largest value associated with a duplicate occurrence 3
Value returned from Formula changes with the Date 6
Get the max value of a column given the current date (this is hard!!!) 1
Help with this challenging VBA coding 3

Top