# Excel - IF Function Problem - Expert Solution

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

I require a name on one field to match a name ('DATA'!AL17), to those on another sheet, within a range of names (SUBURBS!\$A2:\$A1659), which also contains fields of demographic data, if the names match, return one of the data sets within that range (the average income of that suburb). This formula currently returns \$0.00 =IF(SUBURBS!\$A2:\$A1659='DATA'!AL17,SUBURBS!\$G2:\$G1659,0)
Solved by D. D. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 09/05/2018 - 06:00
employees 25
User 09/05/2018 - 06:01
team=i am the only one
Excelchat Expert 09/05/2018 - 06:01
Hello!
User 09/05/2018 - 06:01
hello
Excelchat Expert 09/05/2018 - 06:01
Welcome to Excel chat.
User 09/05/2018 - 06:01
thanks
Excelchat Expert 09/05/2018 - 06:02
I understand that you are looking for a formula to search and match data.
User 09/05/2018 - 06:02
correct
Excelchat Expert 09/05/2018 - 06:02
Please share some sample data so that a formula can be worked out.
User 09/05/2018 - 06:04
attached
Excelchat Expert 09/05/2018 - 06:04
Ok. Thanks for the sample data.
Excelchat Expert 09/05/2018 - 06:04
Which column in sheet2 contains Average Weekly income?
User 09/05/2018 - 06:05
Average Weekly income = G
Excelchat Expert 09/05/2018 - 06:05
Ok. Great.
Excelchat Expert 09/05/2018 - 06:05
Please see the cell D2 now.
Excelchat Expert 09/05/2018 - 06:05
User 09/05/2018 - 06:06
I think that does - much easier than what I had - thankyou
Excelchat Expert 09/05/2018 - 06:06
Great! Let me explain this formula to you.
Excelchat Expert 09/05/2018 - 06:06
When you have to do some kind of Lookup in a table, VLOOKUP is the answer.
Excelchat Expert 09/05/2018 - 06:07
It need 4 inputs, First: The value that need to be searched.
Excelchat Expert 09/05/2018 - 06:07
Second: The range where it need to be searched.
Excelchat Expert 09/05/2018 - 06:08
But the range should have first column as where the value need to be searched. And this column can be any a column and all other column should come right after that.
Excelchat Expert 09/05/2018 - 06:08
Third: The index of the column starting from 1st column, which need to be returned in case a match is found.
Excelchat Expert 09/05/2018 - 06:08
Fourth: If the data is sorted or not.
User 09/05/2018 - 06:09
cool, that makes much more sense
Excelchat Expert 09/05/2018 - 06:09
This also assumes that 1st column in search range has unique values, else first match will be returned.
Excelchat Expert 09/05/2018 - 06:09
I hope that will help.
Excelchat Expert 09/05/2018 - 06:09
Let me know if you have any question regarding the formula.
User 09/05/2018 - 06:10
That does - amazing, I have been working on this for 2 days - solved within minutes - well done!
Excelchat Expert 09/05/2018 - 06:10
User 09/05/2018 - 06:10
Thankyou - I will recommend this service!
Excelchat Expert 09/05/2018 - 06:10
You can close this session now by clicking 'END' button. Hope to see you here again soon. Have a nice day ahead.

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.