# Lookup Help

#### Warn

##### New Member
Helped her with one vlookup problem but these last two stumped me.

Add a column that shows if a ZIP code has a high population of children and a low number of competitors. High child population is anything greater than or equal to 30% of children population over total population. Low competitors is if a ZIP code has less than or equal to two competitors.

Add a column that shows what ZIP codes would qualify as being potential locations for a new store. A potential location is any ZIP code that has high children and low competition, or an average household income greater than \$50,000. However, a ZIP code cannot be considered for a new store if it has more than five competitors.

Any help would be appreciated.....
Excel Workbook
ABCDEFG
2Zip CodeCitySTPopulationChild Population Age 0-14Avg Household IncomeNumber of Competitors
302138CambridgeMA19987688225\$ 62,096.334
402777SwanseaMA38357070560\$ 47,030.327
506385WaterfordCT22226156806\$ 52,744.963
Potential Locations
Excel 2010

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### Warn

##### New Member
Anyone?
I keep getting an error.

#### Dryver14

##### Well-known Member
Try This in H3

=IF(G3>5,"No",IF(F3<50000,"No",IF((E3/D3)*100>29,"Yes","No")))

#### Marcelo Branco

##### MrExcel MVP
Hi,

If i understood correctly you want two new columns

First
Add a column that shows if a ZIP code has a high population of children and a low number of competitors. High child population is anything greater than or equal to 30% of children population over total population. Low competitors is if a ZIP code has less than or equal to two competitors

Formula
=IF(AND(E3/D3>=0.3,G3<=2),"YES","NO")

Second
Add a column that shows what ZIP codes would qualify as being potential locations for a new store. A potential location is any ZIP code that has high children and low competition, or an average household income greater than \$50,000. However, a ZIP code cannot be considered for a new store if it has more than five competitors.

Formula
=IF(OR(AND(E3/D3>=0.3,G3<=2),AND(F3>50000,G3 <= 5)),"YES","NO")

HTH

M.

Last edited:

Replies
3
Views
137
Replies
10
Views
1K
Replies
2
Views
243
Replies
7
Views
130
Replies
5
Views
490