1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Lookup function to return a group of cells based on search?

I have a project I made for a table top game that has a bunch of unit cards in s spreadsheet, I am looking for a way to create a "Force Builder" in another sheet, most-likely in the same workbook that will allow me to look up units based on at least one piece of information in the card and display the whole card.

This is the area I would like to have show up. Any tips would be greatly appreciated.

https://preview.redd.it/g61jww4nw0sg1.png?width=538&format=png&auto=webp&s=ed3da7e69ddc279ccb918d3cf2511c279669ab9e

submitted by /u/simpson95338
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article