Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

can i create a formula to cross reference data from 2 different workbooks? ie if a number appears in column one in workbook 1 then input the data related to that number into a separate workbook?
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 21/08/2017 - 11:20
Welcome, Thanks for choosing Got It Pro-Excel.
Excelchat Expert 21/08/2017 - 11:21
I understand that you need help with formulas
User 21/08/2017 - 11:22
Excelchat Expert 21/08/2017 - 11:22
Are you currently working on MS Excel or Google Sheets?
User 21/08/2017 - 11:22
ms excel
Excelchat Expert 21/08/2017 - 11:23
Can you explain further what you're expected output?
User 21/08/2017 - 11:25
i need to be able to create a formula to pick out data from one workbook and IF true then transfer data to another workbook is that doable? also im complete beginner re formula and this is fairly complex
Excelchat Expert 21/08/2017 - 11:26
What data exactly are we looking at? I renamed Sheet1 as Workbook1
Excelchat Expert 21/08/2017 - 11:26
and created a 2nd sheet and renamed it Workbook2 so we can replicate what you want (just using different sheets.
User 21/08/2017 - 11:30
essentially i need to lookup the number in workbook one and if correct complete the customer hire and off hire dates to workbook 2?
User 21/08/2017 - 11:30
does that make sense?
User 21/08/2017 - 11:30
i have 250000 entries that i have to manually sort and transfer info between the 2 workbooks!
Excelchat Expert 21/08/2017 - 11:31
just the customer hire and off hire dates?
User 21/08/2017 - 11:31
Excelchat Expert 21/08/2017 - 11:31
Looks like you also have Customer column there
User 21/08/2017 - 11:32
customer, hire and off hire dates from the number
Excelchat Expert 21/08/2017 - 11:32
Got that.
Excelchat Expert 21/08/2017 - 11:32
Entering Explanation Phase
Excelchat Expert 21/08/2017 - 11:34
Excelchat Expert 21/08/2017 - 11:34
We are running out of time. Please click this link where we can continue chatting for a few minutes after the timer runs out.
Excelchat Expert 21/08/2017 - 11:34
Reply to the chat bubble located in the upper-right corner of that page.
Excelchat Expert 21/08/2017 - 11:36
Excelchat Expert 21/08/2017 - 11:36
Do you have the same field name for your fields?
User 21/08/2017 - 11:36
can do
Excelchat Expert 21/08/2017 - 11:36
What do you mean?
User 21/08/2017 - 11:37
yes i do
Excelchat Expert 21/08/2017 - 11:37
Oh ok.
Excelchat Expert 21/08/2017 - 11:37
Because if the fields are completely the same then we can use a dynamic formula
User 21/08/2017 - 11:38
yes exactly the same
Excelchat Expert 21/08/2017 - 11:39
Can you look at Workbook2?
Excelchat Expert 21/08/2017 - 11:39
And look at cell B2
Excelchat Expert 21/08/2017 - 11:39
Do you see that it came back as error?
User 21/08/2017 - 11:40
Excelchat Expert 21/08/2017 - 11:40
That's because the header is "CUSTOMER "

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc