**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.*