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
Attachment | Size |
---|---|
Data Sample.xlsx | 288.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