sum1 plz help me understand vlookup function

  • Thread starter Thread starter flick
  • Start date Start date
F

flick

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 :mad:
 
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.
 
flick said:
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 :mad:
Click to expand...

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/
 
Back
Top