EXCEL Question for Work (Low Tech)

[sub-80]

Hey;

I am using excel as Office is the only identical software in all the PCs in my workplace. What I want to do for example: I have a sheet with equipment for each location in columns and another sheet with database of equipment name and condition (run, breakdown, maintenance,etc.) So what I want is to have a 3rd sheet with all the locations and number of breakdowns per locations.

It would be similar to Countifs but instead of the criteria being a cell it would be an array of cells


Any help?


Thanks.

 

[Aikouka]

Typically, generating fully dynamic content in Excel would require a macro. There are some crazy things that you could do with array formulas, but I don't know if I'd recommend it. I've worked with them in the past, and they're kind of slow and generally a pain to work with.

Now, if you have some static values and you just want to fill out some attributes, you can just perform a vlookup to grab the data from one of the other two sheets. For example, it sounds like your first sheet could just have a column inserted beside the equipment name, and a vlookup uses that name to retrieve the status from the second sheet. Keep in mind that if you do use vlookup, it requires the lookup value to be in the first column of the source table.