LinkBack URL
About LinkBacks
I extract data from one column using LARGE but want to add a second column as per the attached. What formula needs to be enters in col J to rturn the date?Book2.xlsx
I extract data from one column using LARGE but want to add a second column as per the attached. What formula needs to be enters in col J to rturn the date?Book2.xlsx
JonnieB,
An index/match in K2, like this:
will do as you require.
=INDEX($C$1:$F$1,MATCH(I2,C2:F2,0))
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
That does the job and works just fine.index/match are function I've not used vefore so I've some learning to do!
Thanks for your help.
Jon
Glad I could help. If you're unfamiliar with index/match, have a look at my last post (#15) in this thread:
http://www.excelforum.com/excel-gene...74#post2994374
which gives an overview of how it works - you may find it a useful introduction.
And thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks