Hi, first tme post Im usually pretty good with Excel but I am having trouble with a vlookup function any help would be greatly appreciated
I want to calculate the commision on sales from each month.
I have one 2 column table like this
Sales:....... Commission
1-99 ............3%
99-199 .........6%
...etc
Than I have a table which actually shows the sales for that month,
such as:
Month: ...............Sales: ..............Commission:
February............ 25 ..................(VLOOKUP)
March ................45...................(vlookup)
I would like the Vlookup function to compare the sales with the commisions table and than input the corresponding commision from the sales.
any help would be greatly appreciated.
I want to calculate the commision on sales from each month.
I have one 2 column table like this
Sales:....... Commission
1-99 ............3%
99-199 .........6%
...etc
Than I have a table which actually shows the sales for that month,
such as:
Month: ...............Sales: ..............Commission:
February............ 25 ..................(VLOOKUP)
March ................45...................(vlookup)
I would like the Vlookup function to compare the sales with the commisions table and than input the corresponding commision from the sales.
any help would be greatly appreciated.