samedi 30 septembre 2017

Excel nested if. If cell A2 do this, if cell B2 do this, if cell b3 do that

Ok im a little rusty on my excel. I have data currently on a sheet that are in 3 tables basically the first one asks them to put in a value and the next 3 columnns return values. So they put in a state and the metro areas are returned in one cell, cities in the next, and streets in the last. I also created a table under it that does basically the same except they enter the metro it will then display states next to it. cities to the right of that and then streets to the right of that. finally one more for table that they put in the city and streets are returned next to it. I would like to combine these by having 3 columns up top and they enter one particular area to one of those cells. So it would be

State | Metro |City ------ | ------ |----- Cell | Cell |Cell

in the cell field they would fill in the lets say the city. Below I have the table with the cells that would determine which cell had text and return the appropiate data. so there would be 3-4 cells for the Metro, Cities, Streets, States. If i put a city in the first 3 cells wouldnt return a value but streets would return the streets for that city. If i put a state in it would retrun the Metro areas, cities, and streets. I basically just need formula to check which cell has data to run the particular formula i have to return that data.

Below is what i want it to look like. and what it currently is.

http://ift.tt/2xKvPDv

http://ift.tt/2yAItEp

Let me know if there is something else i can clarify.

Aucun commentaire:

Enregistrer un commentaire