In an excel sheet, say we have some set values in A2 to A50 and B2 to B50 and
C2 to C29. Now we need to compare say A30 onwards to cell values A2 to A29
and B30 onwards to B2 to B29 and if both values found then the row in which
both value found, the value in column C will be the value in the C column of
cells C30 onwards. Hope this example explains the problem clearly.