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

Tagged with

#Excel alternatives for data analysis
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#Force Builder
#lookup function
#unit cards