Here is the scenario as best I can relate it.
In Spreadsheet 1, I have a Material I am looking up in Spreadsheet 2 via VLOOKUP.
My problem is that I have multiple cells in Sheet 2 which I am trying to look up with VLOOKUP which need to be found and then MERGED into one cell in Sheet 1.
EXAMPLE:
In Sheet 1 cell A1, I need to merge three or four cells which match the word WIDGETS in Sheet 2.
If I search Column A in Sheet2, and Column B has three of four fields which match my search criteria, I need them to be found and merged into Cell A1 in Sheet 1.
Does this required a multiple VLOOKUP argument or can it be done another way?
All help is appreciated.
In Spreadsheet 1, I have a Material I am looking up in Spreadsheet 2 via VLOOKUP.
My problem is that I have multiple cells in Sheet 2 which I am trying to look up with VLOOKUP which need to be found and then MERGED into one cell in Sheet 1.
EXAMPLE:
In Sheet 1 cell A1, I need to merge three or four cells which match the word WIDGETS in Sheet 2.
If I search Column A in Sheet2, and Column B has three of four fields which match my search criteria, I need them to be found and merged into Cell A1 in Sheet 1.
Does this required a multiple VLOOKUP argument or can it be done another way?
All help is appreciated.