If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sum1 plz help me understand vlookup function
i'm doing an assignment for my accountancy course and i need to use the
v look up function in order to determine calculations of wages.... for example.... i've attached my assignment inorder for u to understand my problem a little more.... i'm finding it a lil tdifficult as i'm using "the 2000 stable office 2000" text book... it describes the function breifly but i can't fully understand it.... sumone plzzz help me i'm getting really ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
sum1 plz help me understand vlookup function
Assume you have a table like this with data starting in the upper left
corner of the sheet (cell A1) Act Value A 10 B 20 C 5 D 200 E 20 in Cell F1 for example put in C in G1 put in the formula =Vlookup(F1,$A$1:$B$6,2,False) this will return 5 See the help in Excel itself - this is pretty clear. -- Regards, Tom Ogilvy flick wrote in message ... i'm doing an assignment for my accountancy course and i need to use the v look up function in order to determine calculations of wages.... for example.... i've attached my assignment inorder for u to understand my problem a little more.... i'm finding it a lil tdifficult as i'm using "the 2000 stable office 2000" text book... it describes the function breifly but i can't fully understand it.... sumone plzzz help me i'm getting really ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
sum1 plz help me understand vlookup function
"flick" wrote...
i'm doing an assignment for my accountancy course and i need to use the v look up function in order to determine calculations of wages.... for example.... i've attached my assignment inorder for u to understand my problem a little more.... i'm finding it a lil tdifficult as i'm using "the 2000 stable office 2000" text book... it describes the function breifly but i can't fully understand it.... sumone plzzz help me i'm getting really Frustrating school assignments are meant to separate those with realistic professional prospects from those who should resign themselves to flipping burgers at McDonalds. Get used to the idea that this maddening assignment is merely a feeble imitation of some of the more demanding assignments you may get (if anyone thinks you're any good) when you enter the real world. Excel online help and several other threads in this newsgroup should provide adequate material from which to learn this function. But if you still need help with this, try http://homepage.ntlworld.com/noneley/ |
Thread Tools | |
Display Modes | |
|
|