Hi All,
I have a Workbook with a Main Sheet ("Main Page") Cell O6 referencing a
certain cell value. This cell contains the Last Name I'm looking to match on
another page. The next page "Test Results Data" cells A2:A21 contain the
needed look-up Last Name. I also need to match another cell along with the
Last Name (would come in the same row as last name). Cells C2:C21 which is
the Employee Number are also needed to confirm last name validity.

I've started by using the following formula on the "Main Page" which works
fine - - - =IF(MATCH(O6,'Test Results Data'!A2:A21,0)<"","Yes",""). I'm still
in need of another part (meaning Offset Formula) to have this also look 2
Cells to the Right to see if corresponding cells C2:C21 also has a value <"".

Any help would be greatly appreciated. I've come close, but I can not quite
get it and I'm close to ripping out patches of hair trying to finally figure
this one out!!!

Thanks in advance - Jenny B .