Perhaps an IF/VLOOKUP Solution...

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SamuelT" <SamuelT.1w67yb_1128081904.2293@excelforum-nospam.com> wrote in
message news:SamuelT.1w67yb_1128081904.2293@excelforum-nospam.com...
>
> 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
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
> http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=472057
>

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


"SamuelT" <SamuelT.1w67yb_1128081904.2293@excelforum-nospam.com> wrote in
message news:SamuelT.1w67yb_1128081904.2293@excelforum-nospam.com...
>
> 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
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=472057
>