nested vlookup with if statement

[maacmaac]

I am trying to match up two sheets and I the match criteria is based on the data from columns B, C, D, E, and G.

Sheet 1 contains ~20,000 line items of data. Sheet 2 contains ~250 line items. I am comparing the info in sheet2 vs. the data in sheet1. Both sheets are formatted the same.

For each row in sheet2, I need to compare against all rows in sheet1. For example; for the first row in sheet2, determine if there is a row in sheet1 that contains the exact same data for columns B, D, E, and G (all must be true) and the data in column C is False.

Examples

match found data would be as follows:
sheet1
columnB columnC columnD columnE columnF columnG
822177...Sell.........380......65.96.....ignore.....166764100

sheet2
columnB columnC columnD columnE columnF columnG
822177...Buy.........380......65.96.....ignore.....166764100

match not found data would be as follows:
sheet1
columnB columnC columnD columnE columnF columnG
822177...Sell.........380......65.96.....ignore.....166764100

sheet2
columnB columnC columnD columnE columnF columnG
822177...Sell.........380......65.96.....ignore.....166764100

I have attached spreadsheet if needed that shows example layout and desired results. Thanks for any comments.

[NBVC]

Try:

Please Login or Register  to view this content.

copied down

[maacmaac]

Thanks for quick response. Solution is working. Exactly what I was looking for.