I need help about index function.i need some sheets on my file.please look at and help me.
I need help about index function.i need some sheets on my file.please look at and help me.
Last edited by kalles; 05-31-2012 at 05:16 AM.
Hi
1)Pls, spend a minute and change your title, according the forum rules.
2) As we get an error in your formula, pls explain us where are you looking(INDEX) and Where compare the bordro!C4.(MATCH)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
i would like to see on sheet bordro.how many hours worked employee.how much is his hourly pay.in my older post about vlookup have file quiz2.xlsx.on ths file all function workin.but there only 3 employee.i want this function for so many people.i have tried but could not.
Last edited by kalles; 05-29-2012 at 03:43 AM.
i think there is a problem with your sheets. im not entirly sure who your ment to be looking up.
the employ you have on the bordro does not have a hourly rate set and there are 2 lists of empolye.
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
It looks like you need this formula in bordro!C5:
=INDEX(anel!C3:C397,MATCH(C4,anel!D3:D397,0))
BTW: you seem to be posting employees' personal information - not good
Last edited by Cutter; 05-29-2012 at 05:38 AM.
I have solved it.thank you.this people names are not real
OK, that's good. Don't forget to mark your thread as SOLVED (see instructions in rule #9 by clicking Forum Rules @ top of page).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks