Perhaps an IF/VLOOKUP Solution...

Hello again,

OK - here's my next problem.

I need to check a range of cells that correspond to various computer systems being used on a project.

Each system has it's own column. If there is an 'X' in the column (i.e. this system is used in the project), I'd like Excel to reference what the project is, and then display the name in another cell. I'm thinking there is an IF and VLOOKUP solution to this problem, but can't quite work out the correct way to express the formula.

For your information, the cell range for the VLOOKUP is called 'all_data'. The range of columns with the systems is BV:CG (columns 55 through 66). The project name is in column C (column 3).

Can anyone help?

TIA,

SamuelT