data in 2nd column associated with =MAX(H1:H100) from another colu

T

tcek

I have two columns. Column one has the dates of the month and the second
column has inventory amounts for that date. The inventory amounts is paste
linked to another worksheet. I have the data in column 2 to show up in the
linked worksheet for the latest date. I am using =max(date1...date31) to find
the lasted date. Any suggestions to transfer the associated data to the
linked field would be greatly appreciated
 
T

T. Valko

Kind of vague, maybe this:

Assume you have this formula in cell A1:

=max(date1...date31)

Then:

=INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0))
 
M

Mike H

Hi,

A least for me you will have to explain this a bit more clearly and
preferably with some sample data and expected result.

Mike
 

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

data associated with latest date 5
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
formula to work from data column 1
adding multiple values from matched search results 3
return fields associated with max value record 9
help with formula and multiple associated data sets 1
Making data in appear in one worksheet from another 2
Sectioning rows of text based on value of associated data column 1

Top