I have a workbook with 3 worksheets A, B and C. I want to look up values from column 1 of worksheet B and if it doesn't find a match in column 1 of worksheet A, then return the information contained in the row of its entry in worksheet B. The results are to appear in new worksheet C without blank rows. Can anybody suggest an appropriate formula to use?
Many thanks in advance
Lyndon
Many thanks in advance
Lyndon