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:439C75AC4960428794BF1A564780CA2B(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 