Hi,
I have created a spreadsheet (example attached) where I want to display names next to the formula result as per the spreadsheet. I have only just discovered the "large" formula and have been able to add that to my spreadsheet but It only returns the value of the given range. What I need is to extend the range to capture the names also.
Hope this makes sense?
Thanks to anyone who takes the time to read this and for any anticipated solutions.
Tony
Last edited by Tony0731; 01-16-2018 at 11:21 AM. Reason: no attachment sent
Hi Tony. There is no attachment.
To add an attachment, click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
You use the LARGE function for the values, then VLOOKUP or INDEX MATCH in the adjecent column for the associated name.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks, Done that now!!
Hi AliGW,
I am fairly new to all this and am not 100% sure how to do this, could you possibly give me an example on my attached spreadsheet?
Thanks in advance,
Tony
In F11:
=INDEX($C$5:$C$9&" "&$D$5:$D$9&" "&$E$5:$E$9,MATCH(G11,$G$5:$G$9,0))
Copy down.
Wow!! I am amazed at how fast you came up with that formula thanks a million. I honestly thought that I would have had to type something like =vlookup........ etc....
Thank you soo much for your help. This is an amazing site for help, and believe me I have much to learn.
Best regards,
Tony
Yes, you have a lot to learn, but keep visiting this place and you will learn fast. Most of what I know I learnt here.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Done!! Thank you for taking the time to help.
Pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks