I am trying with no success to write a formula that looks at spreadsheet 1 in cell B3 and then looks for that match in spreadsheet 2 in cell A1 and then returns all the data that matches Cell B3 in spreadsheet 1. This will be multiple data and I want it all in one cell with a dropdown menu. I'm told it can be done but no one can show me who. Please help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula on returning multiple matches
- Thread starter rsat
- Start date
Similar threads
- Question
