Perhaps an IF/VLOOKUP Solution...

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
 
B

Bernard Liengme

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
 
J

John F. Collins

There is probably a Match and Index solution to your problem, but as Bernard
says, you have not provided sufficient detail.
 
Top