All solutions IF Expert Solution – Excel IF Problems

Excel - IF Function Problem - Expert Solution

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

I'm looking for a formula or format for if there is data in c4 on a sheet... It adds extra information underneath
Solved by X. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 09/07/2018 - 03:17
Hello, I hope you are having a good day. I am here to help with your question.
User 09/07/2018 - 03:18
Hi
User 09/07/2018 - 03:18
In a nutshell, If I was to put a client's name in lets say A3
User 09/07/2018 - 03:19
How can I run a code for B3 to provide me the address so then I don't have to write it out over and over
Excelchat Expert 09/07/2018 - 03:19
May I ask a few questions to confirm my understanding?
User 09/07/2018 - 03:20
Sure
Excelchat Expert 09/07/2018 - 03:20
do you have a table where you have a table with exhaustive information?
Excelchat Expert 09/07/2018 - 03:21
like clientname and addresses?
User 09/07/2018 - 03:21
Yes so I have a master copy where I keep all my client's details
User 09/07/2018 - 03:22
And I would like to transfer only some of the information onto a sheet for us to print out
Excelchat Expert 09/07/2018 - 03:23
so, can we design a vlookup to look for client's name in that list and populate address automatically in the next column?
User 09/07/2018 - 03:24
Yes that's what I'm after
Excelchat Expert 09/07/2018 - 03:24
there is a risk with linking formulas to another file. if you share this file or the file to which you link the formula is moved or renamed, you might end up with an error
Excelchat Expert 09/07/2018 - 03:25
I suggest that it is better to have a copy of the Master data in another sheet in the same file
Excelchat Expert 09/07/2018 - 03:25
let me demonstrate your requirement
Excelchat Expert 09/07/2018 - 03:25
in the sheet that we can see
User 09/07/2018 - 03:26
Okay
Excelchat Expert 09/07/2018 - 03:26
So, lets say sheet 2 has masterdata
Excelchat Expert 09/07/2018 - 03:26
we will design a formuua on sheet 1
Excelchat Expert 09/07/2018 - 03:27
so
Excelchat Expert 09/07/2018 - 03:27
now lets add a client name in A2
User 09/07/2018 - 03:28
What was the formula used? I missed it
Excelchat Expert 09/07/2018 - 03:28
so you see, with this formula, now you will have the address populated. Let me explain a little on how to use vlookup
Excelchat Expert 09/07/2018 - 03:29
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row.
Excelchat Expert 09/07/2018 - 03:29
=VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE)
Excelchat Expert 09/07/2018 - 03:29
have a look at this
Excelchat Expert 09/07/2018 - 03:29
I am looking up value in A2
Excelchat Expert 09/07/2018 - 03:30
in the table which is in Sheet2 column A to C
Excelchat Expert 09/07/2018 - 03:30
display details in column 2
Excelchat Expert 09/07/2018 - 03:30
FALSE looks for exact value of A2 in the table
Excelchat Expert 09/07/2018 - 03:30
TRUE looks for approximate value
Excelchat Expert 09/07/2018 - 03:31
please be aware that the value you are looking for (i.e A2) should be in the first column of the table in which you are looking for
Excelchat Expert 09/07/2018 - 03:31
Now Lets say you want to display contact number automatically
User 09/07/2018 - 03:31
Is this on Sheet 1 or 2 you're conducting the formula?
Excelchat Expert 09/07/2018 - 03:31
Sheet 1
Excelchat Expert 09/07/2018 - 03:32
to display contact number
Excelchat Expert 09/07/2018 - 03:32
I will lookup A2
Excelchat Expert 09/07/2018 - 03:32
in our Master data
Excelchat Expert 09/07/2018 - 03:32
we see that contact number is third column in our table
Excelchat Expert 09/07/2018 - 03:33
have exact match
Excelchat Expert 09/07/2018 - 03:33
so FALSE
Excelchat Expert 09/07/2018 - 03:33
now when you are using exact match if the client name is not in the Master data you will see #N/A
Excelchat Expert 09/07/2018 - 03:34
I will send a copy of this sheet for your reference and to play around to explore more
User 09/07/2018 - 03:34
Thank you
User 09/07/2018 - 03:34
Where will you be sending this file?
Excelchat Expert 09/07/2018 - 03:35
Here you are
[Uploaded an Excel file]
Excelchat Expert 09/07/2018 - 03:35
please feel free to explore more
Excelchat Expert 09/07/2018 - 03:35
this will help you a great deal with a lot of things
Excelchat Expert 09/07/2018 - 03:35
I hope I answered your question satisfactorily.
Excelchat Expert 09/07/2018 - 03:36
I would love to receive your feedback.
Excelchat Expert 09/07/2018 - 03:36
Have a fantastic day :)

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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc