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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,759
Office Version
  1. 365
Platform
  1. Windows
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
 

mtapp

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,671
Office Version
  1. 365
Platform
  1. Windows
In what way did it not work?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,777
Messages
5,638,275
Members
417,019
Latest member
PKDP

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
Top