IF statements with VLOOKUP

March 3, 2010 at 19:39:22
Specs: Windows Vista

I've been trying to nest an IF statement with VLOOKUP. My problem is....


Hours Worked

On a master sheet.....

Base Pay

Commission Rate

Would someone help me make a nested statement that will grant this person 0.030 commission and calculate the total commission if he/she exceeds a $200 per hour quota?

My prof told me to look at Excel help, for help. I'm lost so any guidance would be greatly appreciated!

See More: IF statements with VLOOKUP

Report •

March 4, 2010 at 00:03:24
If you followed your prof's advice and used the Excel Help files, you'd see that VLOOKUP usually involves a lookup_value and a table_array. In other words, something to look up and a table (or list) of data in which to look it up in.

I don't see anything in your example data that requires a VLOOKUP. Are you sure you have told us everything we need to know to point you in the right direction?

BTW...since this is homework, we'll try to nudge you in the right direction without giving you a direct answer.

Report •

March 4, 2010 at 03:45:07
IF statements with Vlookup. Where's the nudge?

Report •

March 4, 2010 at 04:26:31

Perhaps you missed my point.

I don't see anything in the OP's example data or question that shows a need for a VLOOKUP. Before I nudge him in the wrong direction, I'd like a little more info.

Feel free to give him a nudge based on the subject line. I'd prefer to get a better understanding of why he mentioned VLOOKUP in the first place.

Report •

Related Solutions

March 4, 2010 at 06:15:40
Hi PappyP,

Like DerbyDad03, I do not see anything in the information provided that would require the use of VLOOKUP.

Your problem basically requires two calculations.

1. The rate of making sales
2. The rate of pay both with and without commission

Use an IF statement to decide whether to pay base pay only or base pay plus commission.

Suggesting that VLOOKUP() is not required was a pretty good nudge, unless of course you haven't provided all the relevant information.


Report •

March 4, 2010 at 07:21:48
Hey, pappyP...

When I responded, I didn't realize that you were the OP. I didn't check the username...I just assumed it was someone else. Sorry!

What I said about VLOOKUP still stands, but I would have said it differently had I realized that it was you that responded.

That said, we'd like to help, so maybe we're just missing a piece of information or two that explains what you are trying to do.

For example, if an IF with VLOOKUP is required, tells us what you are looking up and what the IF criteria and results should be.

If you just want to see what an IF and VLOOKUP formula might look like, Google IF VLOOKUP for lots of different combinations/examples. Perhaps that will get you started.

Report •

Ask Question