OT: Need a little excel help

[RobertE]

Using excel that came with office XP.

Anyway what I am doing is making a pay sheet. I get paid differently by what job I do. So what I need the sheet to do is this.

When I enter the job code in the job box on the job line, it then automaticly enters the $ amount in the pay box. Rinse & repeat. There are about a dozen or so job codes.

I know it can be done and that I need to make a table of some sorts with the job codes and the corresponding $ amounts, just don't know how.

 

[Smoke]

There are a couple of solutions.

I believe the "lookup" function is probably what you need. Here is a description.

You could also use nested "If ... Then ... " statements. I probably have some of the longest "If ... Then ..." statements in the world. lol 😱

 

[RobertE]

Thanks Smoke. The VLOOKUP function is what I needed. The IF statements only allow me to go 7 IFs deep. Wish I would have paid more attention in those CS classes all those years ago instead of screwing around. 😱