Hi,
I need to populate two columns based on a reference sheet like below.
For example the below is reference -
Position Ability Speed
1 High High
2 Medium High
3 Low High
4 Low Medium
5 Low Low
And now on another sheet of excel using the above reference I should be able to 'default' automatically using a Formula or Function the Ability & Speed values when there is Position value entered by User.
Example when - Position Ability Speed
1 High High
Request to share your suggestions. Thanks
Vk
Bookmarks