I have a spreadsheet where I am attempting to lookup an ID # (in yellow) and return multiple results from Sheet 1. I do not clearly understand index and match formulas so I need something specific to my spreadsheet. Cells in Blue are the desired results. Can anyone help?
Enter this array formula in A5, copy across and down
Formula:
Please Login or Register to view this content.
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
grifter0.xlsx
Last edited by AlKey; 03-14-2016 at 11:46 AM. Reason: added excel file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Or you can use a pivot table
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thank you so much. This is exactly what I needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks