Excel Help with VLookup and IF
Posted on 2012-08-24
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?