Formula assistance

mtapp

New Member
Joined
Dec 17, 2009
Messages
24
Office Version
  1. 2016
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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Maybe something like this. It would also help to know which version of Excel you are using.

Sheet2
Book2
ABC
1Data2Test2
2Data1Test1
3Data3Test3
4Data5Test5
5Data4Test4
Sheet2
Cell Formulas
RangeFormula
C1:C5C1=INDEX(Sheet1!$B$1:$B$5,MATCH(B1,Sheet1!$A$1:$A$5,0))


Sheet1
Book2
AB
1Data1Test1
2Data2Test2
3Data3Test3
4Data4Test4
5Data5Test5
Sheet1
 
Upvote 0
This does not work. I am using 2016. I used to be able to just use the lookup function , but that no longer works. Looks like my example did not format correctly when I hit post
 

Attachments

  • Capture.JPG
    Capture.JPG
    100.8 KB · Views: 7
Upvote 0
In what way did it not work?
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top