ps.

Debra Dalgleish has lots of notes on =vlookup()"
http://www.contextures.com/xlFunctions02.html
and
http://contextures.com/xlFunctions02.html#Trouble

ASasser wrote:

I am paid by the line typed/edited. I want to make a spreadsheet that will
allow me to enter the report type and the line count and have the spreadsheet
calculate the pay I will receive for each report. For instance, this is how
I have it set up so far:

Column C Column D Colulmn E
Report Type # of Lines Pay

VR 14
ST 25

Ok. My VR pay is $0.025 per line and ST pay is $0.065 per line.

Is there a way to make this work so I can just copy the same formula for
each line in Column E? I'm using Excel XP (2002).

Thanks.

--

Dave Peterson