From: "David Biddulph" groups [at] on 8 Mar 2010 15:55
You can find the syntax of the VLOOKUP function by typing VLOOKUP into Excel
"Denise" <Denise(a)discussions.microsoft.com> wrote in message
> One thing, what does the...,2,0) towards the end of the formula mean?
> "Pete_UK" wrote:
>> You would normally set up a table somewhere (on a second hidden sheet
>> perhaps) which will have the person's name and the rate of pay,
>> something like this:
>> John 5.50
>> Fred 10.00
>> Mary 12.00
>> Anne 7.50
>> Suppose this is in columns A and B of Sheet2. Then in D2 of Sheet1 you
>> could have:
>> to give you the cost for that employee (i.e. rate times hours worked).
>> Then copy the formula down as far as needed.
>> Hope this helps.
>> On Mar 5, 10:24 pm, Denise <Den...(a)discussions.microsoft.com> wrote:
>> > On a spreadsheet, the date worked would be in column A; employees' name
>> > are
>> > in column B. An individual maybe listed several times in column B .
>> > In
>> > column C would be # of hours worked that day. What formula could be
>> > used so
>> > I don't have to type the rate of pay (which should stay hidden) for
>> > each
>> > person every day?
>> > Thanks.