Hi all,
I wonder if there is anyone other who can assist me on a small matter.
I have list, in column B the user enters a value, e.g. 21. Then I want to search a secondary tab with the value entered in that column + the value of the column headers. I know that this is not crystal clear and it is hard to explain.
Please see attached file for details.
Br,
MikaelMM_TEST_Book1.xlsx
Administrative Note:
Is your forum profile showing the version of Excel that you need this to work for?
Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.
The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.
Thanks.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I can give you a really easy solution IF you have upgraded to 365 - please update your profile as requested or confirm that you are still using Excel 2003.
Here it is anyway (should work with Excel 2021 or 365):
=TRANSPOSE(INDEX(FILTER(Text!$A$2:$C$10,Text!$A$2:$A$10=B2),,3))
Hi,
thank you! I have updated. I am running it on 365, but I need it to work on 2016 as wellBut I am happy if you can show for 365 too
Another optionFormula:
Please Login or Register to view this content.
What I have showed you above will work on Excel 2021 and later, I believe. Sorry - can't help you with Excel 2016.
The formula I posted will work with 2016, but will need to be confirmed with Ctrl Shift Enter, rather than just Enter
Thank u
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Glad to help & thanks for the feedback.
Re: Search a list with multiple values
with Power Query
it will work in XL2010 to XL365
XL2010/2013 require PQ add-in
Item ID List.1 List.2 List.3 List.4 List.5 A Line 21 AA Line 21 BB Line 21 CC B Line 33 A Line 33 B Line 33 C Line 33 D Line 33 E C Line 33 A Line 33 B Line 33 C Line 33 D Line 33 E D Line 44 AAA E Line 33 A Line 33 B Line 33 C Line 33 D Line 33 E F Line 44 AAA G Line 33 A Line 33 B Line 33 C Line 33 D Line 33 E H Line 44 AAA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks