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
Does that answer your question?
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
I am glad that I could help you today.
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.
