**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a column that is the status (Not Started, In Progress etc.) I want that to equate to my column of % Complete. So if I choose Not Started it automatically will make my % Complete row 0%, In Progress will be 25% etc...

Solved by A. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
03/05/2018 - 02:54

HI

Excelchat Expert
03/05/2018 - 02:54

Welcome to Got It Pro.

User
03/05/2018 - 02:55

Thank you

Excelchat Expert
03/05/2018 - 02:55

Please provide sample in preview.

User
03/05/2018 - 02:57

I want when I choose not started for the percentage to correlate without me having to choose it

User
03/05/2018 - 02:57

Is that possible?

Excelchat Expert
03/05/2018 - 02:57

Ok.

Excelchat Expert
03/05/2018 - 02:57

There are 3 %.

Excelchat Expert
03/05/2018 - 02:58

I can use index formula. Can we list it in the form of table?

Excelchat Expert
03/05/2018 - 02:59

=VLOOKUP(A1,D:E,2,false)

Excelchat Expert
03/05/2018 - 02:59

Vlookup formula will provide the percentage based on the text selected.

User
03/05/2018 - 02:59

Yes that is what I want

Excelchat Expert
03/05/2018 - 02:59

Great.

Excelchat Expert
03/05/2018 - 03:00

Thank you.Please do visit Got IT Pro.

Excelchat Expert
03/05/2018 - 03:00

Have wonderful day and leave a valuable feedback after ending session.

User
03/05/2018 - 03:00

But if it is in a drop down how do I make it realise what one I choose

Excelchat Expert
03/05/2018 - 03:01

It checks the column D and based on the the selection.

Excelchat Expert
03/05/2018 - 03:01

=VLOOKUP(A1,D:E,2,false)

Excelchat Expert
03/05/2018 - 03:01

A1 is the item you choose.

Excelchat Expert
03/05/2018 - 03:01

It searches in column D

Excelchat Expert
03/05/2018 - 03:01

And result it from column E.

User
03/05/2018 - 03:03

I am still confused...

User
03/05/2018 - 03:03

I don't want to have the table on the right, just the drop down

User
03/05/2018 - 03:04

Its okay I will figure it out.

Excelchat Expert
03/05/2018 - 03:04

There is a dropdown in A1 cell.

Excelchat Expert
03/05/2018 - 03:04

Based on the selection, it changes in column B.

Excelchat Expert
03/05/2018 - 03:04

I have preferred table, because, you can change the values easily when needed.

Excelchat Expert
03/05/2018 - 03:05

Instead of including them in the formula.

User
03/05/2018 - 03:05

I don't get it. It's not a problem.

User
03/05/2018 - 03:05

But thank you.

Excelchat Expert
03/05/2018 - 03:05

=VLOOKUP(A1,D:E,2,false)

Excelchat Expert
03/05/2018 - 03:06

Can you see the changes in B1 cell, when there is a change in A1.

User
03/05/2018 - 03:06

I don't want the D and E columns though.

Excelchat Expert
03/05/2018 - 03:06

OK.

Excelchat Expert
03/05/2018 - 03:06

Then, i can write formula.

User
03/05/2018 - 03:06

Okay

Excelchat Expert
03/05/2018 - 03:07

=if(A1="Not Started",0%,if(A1="In Progress",50%,100%))

User
03/05/2018 - 03:08

Okay I got it :)

User
03/05/2018 - 03:08

That is what I am looking for.

Excelchat Expert
03/05/2018 - 03:08

Thank you.

Excelchat Expert
03/05/2018 - 03:08

Great to hear it.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*