Excel Help Needed With Comparison of Ranges

Hello,

I need some assistance dealing with comparison of ranges in my workbook. What my goal is to be able to check Sample 1 against the data field and if it's not present check Sample 2 against the data field and return that text value. I've provide an sample spreadsheet within this post. I've tried If statements, Vlookups, and even Index and Match and I still cannot seem to get the desired results. Any help on this would be greatly appreciated...

Thanks

Xcelhelp87

AttachmentSize
Data Sample.xlsx288.28 KB

Hi Xcelhelp87, None of the

Hi Xcelhelp87,

None of the values in either sample 1 or sample 2 are present in the data field so you will not get anything returned using any lookup. I'm not sure if it is just that the sample you have uploaded doesn't have matches or if there are no exact matches of text between the samples and the data field.

Anyway the following will show a blank cell if there is no exact match with either sample 1 or sample 2:

=IFERROR(VLOOKUP(F2,O:O,1,0),IFERROR(VLOOKUP(G2,O:O,1,0),""))

Regards
Mark

Answer Found

Hi Mark,

This did the trick thank you for taking time to take a look at this..

Thanks,

Xcelhelp87