LinkBack URL
About LinkBacks
Hey guys i really need help in solving this sheet as i have to submit this in a few days could u please help me!!
Lookup functions
Hey guys i really need help in solving this sheet as i have to submit this in a few days could u please help me!!
you havent even tried to do anything,we are not here to do your homework for you
read here about vlookup and hlookup
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/excelhlookupfunction.html
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Originally Posted by martindwilson
sir i have tried and iam not telling anyone to do it for me , i just need some guidance if you opened the file , you would see the questions given to me .
if you open those links and practice them it will show exactly what anyone here will tell you
try a few things then come back perhaps we can show you where you are going right/wrong
Not opened your file, but I am sure martindwilson has give you (the start of) the solution of your solution.
Did you studied the links he has given you?
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
For ex1 you need to use the following
Formula:
Please Login or Register to view this content.
i dont think that the above solution is right as i solved that exercise
billstpierre79 that is so wrong based on the op's question!
Not opened your file, but I am sure martindwilson has give you (the start of) the solution of your solution.
Did you studied the links he has given you?
Please Login or Register to view this content.
yes iam if i still have doubt i will surely tell . Thank you sir
sir i have done these please check and guide on the others and the optional 3 sheet . Thank you
=Vlookup(C4,$H$3:$I$9,2,1)
i already did that exercise , have you tried the rest ?
Did you noticed I changed the formula?
I changed and added the red tekst.
yes , i didnt insert the 1 its for true or false , i didnt insert that because i was getting the answer without it .still Thank you have u tried the rest
1) Have you also noticed I changed the cell reference, since you don't reply on that?
2) Did you have tried the VLookup and HLookup on that questions?
sorry for that , yes iam trying
plz help me solving the sheets
mama don't do homework
and iam not asking to , if you know too much can u help me in solving the optional 2 sheet in the workbook
See my suggestion in #15
Iam taking about THE OPTIONAL 3 SHEET , i have already solved that one which you are talking about
Yes I know, and it can be done with VLookup.
If you see my suggestions earlier, you be able to solve this yourself.
i tried but as the data is unsorted it just doesnt recognize the item code . please help
For the solution in THE OPTIONAL 3 SHEET
In post 11 you find this one.
You have to add an 0 instead of an 1 (see the syntax for VLookup)Please Login or Register to view this content.
Please Login or Register to view this content.
For the solution in THE OPTIONAL 3 SHEET
In post 11 you find this one.
You have to add an 0 instead of an 1 (see the syntax for VLookup)Please Login or Register to view this content.
Please Login or Register to view this content.
yes i did this one !! i want to do optional sheet 1 , 2 , 3 my friend you are not helping at all you are still telling me about that previous question which iam done with
the last argument should be "false" as per the help files, yes you can use 1 or 0 but the helpfile specifies (true or omitted) or ( false)
i have never seen a helpfile for vlookup that tells you to use 1/0 instead of true/false
id like to see you explain to your tutor why you used 0 instead of FalseIf range_lookup is either TRUE or is omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.
Important If range_lookup is either TRUE or is omitted, the values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP might not return the correct value.
For more information, see Sort data.
If range_lookup is FALSE, the values in the first column of table_array do not need to be sorted.
If the range_lookup argument is FALSE, VLOOKUP will find only an exact match. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.
also the purpose of the exercise is to find out what you know do not know..getting the answers directly from someone else is in my opinion defeating the whole object of the exercise you might as well get someone else to sit any test for you
Last edited by martindwilson; 09-01-2013 at 04:17 PM.
@simran555
You don't read well.
You have to use 0 or False in your VLookup function on THE OPTIONAL 3 SHEET
Then you will get the right (an desired) result.
i understood thanks , ihave solved solved optional 1 and 2 , please help me with optional 3
Sorry you are right i found my mistake . Thank you what do you think about that EX 2 sheet because of that hourly rate iam not getting the answer i want
Please add to whom your replying.
#29
You can solve that with VLookup
thanks for your help sir , could you please help me solve the optional 2 sheet as the cost is given for 1 and 3 day , i really dont know how to deal with it . This is the only sheet left
ok i give up we could be here for ever
option 2 would use HLOOKUP
so you look for C (c8) in first row of range
C$2:$H$5 and return the value in the second row of same range
=HLOOKUP(C8,$C$2:$H$5,2,FALSE)
the second part is slightly more tricky
since
Cost - 1 Day
Cost - 2 days
are in rows 3 and 4 but you are only given the value of 1 in cell C9 you need to add 2 to it to get the correct row
=HLOOKUP(C8,$C$2:$H$5,2+C9,FALSE)
Thank you very much sir , the first part is fine but the second one its like adding 2+c9 would get us the answer !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks