# Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at