control box return content of cell indexed

N

nuno .rico

Recently I have developed a excel sheet to assist me on a
payroll system. I would like to enhance this worksheet but
then I would have to solve the following problem:

Example worksheet
A B C
1 code description
2 240 loon
3 241 mortgage
4 245 fees

I designed a control box with input range $C$2:$C$4 and
cell link: $A$1.

Now if I choose for mortgage, then I would like to get the
value 241 instead of the row index value 3 on the A1 cell.

Can you please tell me I can I use the index value of the
control box to access the code value in the B column.

Thanks Nuno
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top