Hello. I have 5 options on an data validation list.
I would like to represent a score for each different option in its adjecent cell.
E.g.
A1 List B1 Score
Mon 10
Tue 20
Wed 25
Any suggestions?
Hello. I have 5 options on an data validation list.
I would like to represent a score for each different option in its adjecent cell.
E.g.
A1 List B1 Score
Mon 10
Tue 20
Wed 25
Any suggestions?
So where do you have your drop-down? Assume it is in D1, then in E1 you can have this formula:
=IF(D1="","",VLOOKUP(D1,A$1:B$5,2,0))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks