Excel newbie here. I have 3 excel sheets. Sheet 1 contains data in columns A and B, sheet 2 contains data in column A.
What I'm trying to do is enter a formula in sheet 3 such that columns A, B and C contain the data of sheet1!A, sheet1!B and sheet2!A respectively.
If I use:
I get an "#VALUE!" in cell C1, instead of values in columns A, B and C.
I found another answer which suggested using an array somewhere. I got a bit further with that. Using:
correctly filled in column A and B of sheet 3. However, once I add in the data from the second sheet, I get an error saying that the shape does not match. I was trying it like this:
Am I missing an easy way to accomplish what I want to do? I'm trying to do it with a formula in column A of sheet 3 since I have to do this for a lot of rows, and referencing each column seperately takes a lot of work.