All -
I have 3 columns of data all with varying data set lengths. What I am trying to do is take columns B and C and make sure I find a match to it in column A. If both B and C match I want to return the values in a new column. Rows 2-5 would be an example of what I want the final data set to look like. The remaining rows is what the raw data currently looks like (over 1000 rows). The three columns do not have the same number of rows of data as shown.
I tried using match index and it does not seem to be working as I would like. If a match is found I want the matches on the same row in new columns. Anything that does not match both columns, I would like a blank returned. Attached is a sample workbook.
Bookmarks