LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bob Newman
 
Posts: n/a
Default Vlookup question please

I think this is vvlookup anyway. I have 3 columns. A has one of several
letters of the alphabet, B has one of about ten different dollar figures, C
is the cell for the lookup amount (commission on a sale).

I want it to figure that if column A contains the letter "N" lookup in a
table to find the commission amount based on the sale amount in column B.
Here's the part that stumps me. I also want the formula to say if column A
has the letter "U" to enter a fixed amount as the commission. Column A may
contain several other letters but "N" and "U" are the only ones I am
interested in.
--

Thanks in advance... Bob


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup against multiple columns/worksheets question JCarter Excel Discussion (Misc queries) 8 March 9th 05 04:59 PM
VLookup Question Jean Excel Worksheet Functions 3 December 28th 04 02:41 PM
question about vlookup ˛ÓBear Excel Worksheet Functions 2 December 14th 04 05:09 PM
Vlookup Question Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM
vlookup question Alex Excel Worksheet Functions 2 November 11th 04 05:11 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"