Formula - Cell value match results in Concat formula

0
votes

I have reference column to trigger a concatenation of data in another sheet. Sample spreadsheet filled with the desired end result data is below.

Sample Schedule spreadsheet

Data validation list is used for Column H of Schedule sheet to select a talk number based on the Column A range in the Lecture History sheet. Once a value is selected for a cell in Column H (cell H3 for this example), I want to produce the following results:

  1. Use the value in cell H3 of Schedule sheet to find a match in Column A of Lecture History sheet
  2. If a match is found, using this Concatenate formula in cell B3 of the Schedule sheet
    =CONCAT('Lecture History'!B2," (",'Lecture History'!A2,")")
  3. If no match is found or the cell H3 of Schedule sheet is blank, return a blank in cell B3 of the Schedule sheet

Any help with developing a formula that does not use VBA is greatly appreciated.

1
indexingexcel-formulamatchvlookupconcat

1 Answers

-1
votes

Answer to this question can be found at Excel Forums, link below.

Excel Forums: Formula - Cell value match results in Concat formula