I am going having trouble with a simple issue. I have data on sheet on in column A and B and data on sheet 2 in column B. I want to return the data from sheet 1, column b, to sheet 2 column 3. I used the formula =IF(Sheet1!A:A,Sheet2!B2,Sheet1!B:B) but it is not working
Sheet 1 Sheet 2
Column A Column B Column A Column B Column C (result I am looking for)
1 Start Test 4 "Long"
2 End
3 Begin
4 Long
5 Ago
6 Last
Any assistance is greatly appreciated. Thank you
Sheet 1 Sheet 2
Column A Column B Column A Column B Column C (result I am looking for)
1 Start Test 4 "Long"
2 End
3 Begin
4 Long
5 Ago
6 Last
Any assistance is greatly appreciated. Thank you