if then advanced filter

Hey friends, Can someone help me to create a sheet where I can get the State name by entering city name. For eg; When I put Barwon Downs(city) in column A, column B should reflect Victoria (state). Attached is the sheet with data.

I need to develop a dynamic report that, given an analyst's initials, the report will return all of the projects that analyst is working on. The source data is a staffing database where each project has an index number, and each project is assigned 1 or more analysts by initials (AVB, LHO...

I am aiming to select a column and highlight any duplicate values as green. I would then like to instruct Excel to do 1 of 2 things in an If Then structure for the given range: 1) filter for any potential green cells and then end sub with "Complete" msgbox OR 2) if no cells were highlighted...

I've spent probably 10 hrs trying to get this to work. I've been trying if then formulas but I cant get it to work. I want to be able to put peoples names on the cards on the first page. The venue cuts those cards up to give to the waiters. I need to check whether the guest wants chicken fish...

I have spreadsheet with two tabs and need to bring 2 tab info into the first one if they meet the category. Tab 1 has cars cell with for example honda toyota ford chev etc Tab 2 has cars and the buyer honda - jim ford - tom honda - bill chev - paula chev - rick ford - vick so any time...

I have a monthly report with over 2,000 entries per column and it is dynamic (number changes monthly). I'm trying to replace individual department names with "department" but keep certain ones the same. For instance- A,B,C,D stay the same but E-Z need to be changed to "department". I first...