Hello All
Is there a way to on the drop down I have a List
1=Full-Time
2=At Least Half-Time
3=Less Than Half-Time
0=Not Enrolled
I am trying to figue out a way that when I select option 2 for example 2 will show up in that column because that column must be an integer.
excelaron,
I would recommend the VLookup() function for this task.
Attached is an example workbook based on the criteria you described.
Row 1 has headers.
Column B contains the data-validation cells.
Column C contains the results.
Column G contains the data validation list items.
Column H contains the results each list item gives.
So in cell C2 and copied down is this formula:
=IF(B2="","",VLOOKUP(B2,$G$2:$H$5,2,0))
Is that what you're looking for?
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks