this was the formula i used: INDEX(Sheet2!A:B,MATCH(Sheet1!A:A,Sheet2!A:A,FALSE),2)
Hi Emanon Im Gilbert. I need your help. I have compared two worksheets. column A from sheet1 and col A from sheet 2. if they match then i bring up the value from column B sheet 2 to column B of sheet 1. now i also want to pull up the date which is also from column B from sheet 2 and place it in a new column C of sheet 1. can you help please?
