Lookup and Append data in Excel Single Column
With reference to below screenshot, Column A,B data are constant and unique values entire column range. Column C data is depends on Column E & F. Column E , F are logs data copies from table and paste in to excel in same sheet. The logs contains "VID,Error_Description" columns data. Each VID may have one or more errors or dont have any errors also. Ex:(As per image) VID-1 ( 400 bad request,500 Internal Server). The column range of E & F are unlimited
So I would like to match each VID in Column E with Column A and fetch corresponding Column E error description in Column F and add to "Result" (Column C). Ex:VID-6: 202 Accepted(in Column E & F ) , so Column C Result for "VID-6" filled with 200 Accepted
If more error description is found for same VID in Column E, then those error description should be appended with comma separator. Ex: VID-1 result is 400 Bad Request,500 Internal Server which is appended with comma seperator
If in Column E does not have any VID that exists in Column A, then specific VID result should be '200 OK'. Ex: There is no VID-7,VID-4,VID-5 in column E, so "result" (Column C) should be filled with "200 OK"
I tried with VLOOKUP formulae but i am not getting proper result.
Input: Column E & Column F
Output: Column C "Result"
Try =IFERROR(TEXTJOIN(", ", TRUE, FILTER($F$2:$F$7, $E$2:$E$7=$A2)), "200 OK")
- Largest sum of consecutive values in row, but is it still consecutive in the cell of the last column?
- Dynamically Inserting a row and iterating over it in VBA?
- VBA class member function and class definition problem continues
- How can I perform COALESCE in power query?
- VBA class member function and class definition problem
- How can I set OptionButton font using VBA For Loop?
- VBA remove string custom salutation name from list table excel
- How to import many dataframes from R into a one Excel file in a simple way?
- How to add a missing column to the Transform Sample File
- Pull data from multiple workbooks based on a dynamic list
- Dependent dropdown list in Excel ,Data Validation and VBA
- Excel Formula: Filter Group based on Smallest Values
- Find column name of active cell within ListObject in Excel
- Strange characters found in XML file and PowerShell output after exporting from Excel: ​
- MID function inside COUNTIFS
- Finding Max of 3 Inputs VBA
- How to align duplicates on the same rows in Excel
- How to use .HTMLBody to hyperlink a cell value?
- Adding cell values, specific to each page, to each header
- Excel VBA macro for URL redirect detecting returns 200 instead of 301 sometimes
- Count with specific values in columns
- Convert IEEE Float hex string to an Excel VBA Single (float)
- Openpyxl or Pandas, which is better at reading data from a excel file and returning corresponding values
- Excel Function: Using a specific criteria to form an array to corresponding values
- How to pass metadata to Google Drive API upload with VBA
- IsError not capturing error returned by expression
- Excel VBA multi select drop down list
- Imported Excel file with dates, came out as numbers, trying to return to date format
- Creating Conditional Column based on another Table's Column
- Convert Range to a table