I am trying to get an excel worksheet to look at another sheet and if data corresponds, insert the information in the first sheet.
Sheet1 contains about 1000 rows of data, column A has a list of 5-digit ascending numbers which are not concurrent (e.g. 12054, 12087, 13078 etc).
Sheet2 contains about 150 rows of data and again column A has a list of 5-digit ascending numbers which are not concurrent. These numbers are the same as in sheet1 (although not all of sheet1’s numbers appear in sheet2).
I want sheet1 to look at sheet2 and if sheet1 finds a number match on sheet2, enter the contents of sheet2’s column B into a column in sheet1. If no number match is found, leave the cell in sheet1 empty.
I have tried to use Lookup function which works after a fashion, but when a cell in sheet1 can’t find a match in sheet2 it enters rubbish data in the sheet1 cell.
Is there a way to do this please?
Sorry for the lengthy text but I find it difficult to describe the layout!