mphackett
asked on
Excel Help with VLookup and IF
Hi there,
Looking for some Excel expertise - I am a rookie in terms of Excel. Here's what I am trying to do:
I have a column of cells with a pull down list that each correspond to a dollar value. I have the VLookup function referencing a table, and it all works fine. You choose the correct item from the pull down, and the correct dollar figure is placed into the next cell. What I would like, is to have the last item in the list as 'other', and have the user prompted for a dollar figure to enter, as well as being promped for a text string which would then be placed in another cell.
Am I asking too much?
Looking for some Excel expertise - I am a rookie in terms of Excel. Here's what I am trying to do:
I have a column of cells with a pull down list that each correspond to a dollar value. I have the VLookup function referencing a table, and it all works fine. You choose the correct item from the pull down, and the correct dollar figure is placed into the next cell. What I would like, is to have the last item in the list as 'other', and have the user prompted for a dollar figure to enter, as well as being promped for a text string which would then be placed in another cell.
Am I asking too much?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again,
Mike