Prev: if formula results in False - can you help?
Next: How to format the phone number
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
help.
--
David Biddulph


"Denise" <Denise(a)discussions.microsoft.com> wrote in message
news:439C75AC-4960-4287-94BF-1A564780CA2B(a)microsoft.com...
> 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
>> etc.
>>
>> Suppose this is in columns A and B of Sheet2. Then in D2 of Sheet1 you
>> could have:
>>
>> =VLOOKUP(B2,Sheet2!A:B,2,0)*C2
>>
>> 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.
>>
>> Pete
>>
>> 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.
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: if formula results in False - can you help?
Next: How to format the phone number