Perhaps an IF/VLOOKUP Solution...

  • Thread starter Thread starter SamuelT
  • Start date Start date
S

SamuelT

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
 
Please give us a fuller description of the worksheet layout.
column A; what is here
column B: has 'X' if computer is used in project
column C: what do you want
best wishes
 
There is probably a Match and Index solution to your problem, but as Bernard
says, you have not provided sufficient detail.
 
Back
Top