Using Index & Match (or similar) to check two columns for a match

Hi

I'm cross matching a set of data which has people's names in it. Unfortunately, the format of the names that will be imported is inconsistent and could be in the 'Firstname Surname' format or the 'Surname, Firstname' format. Whilst I can easily change these around, I need the end user to be able to copy the names in either format. I've stored the names in both formats in the main section but I need a formula which will check two columns instead of one for a match. Only one of the columns will have a match so it's a case of 'OR' rather than match both. I've been trying various options for the last few evenings but I just can't get it to work.

I've attached an example with a formula that checks one column. I just need to expand this to check two columns please. Any help would be appreciated.

Thanks

D

Thanks for quick response. I wasn't able to response earlier because the ExcelForum look to be down but I was able to see your solution in my email and it worked perfectly. Thank you.

Do you know how I might add an extra criteria in? As above but must meet criteria in 1st column and then meet criteria in either 2nd or 3rd column.

Hopefully file attached this time. Example in column C shows it matching two criteria. I needed it to match 1 criteria plus one of 2 other criteria if possible (similar to the example you did for me but adding an additional criteria which must be matched).

ExcelForum - Or Match2.xlsx

Any ideas?

Thanks for this. Works a treat.