Please help me solve these 2 vlookup problems. excel attached here.

[fahadferoz01]

SIR, PLEASE HELP ME THE LAST QUESTION.

 

[fahadferoz01]

I tried solving question 1 by inserting this formula: =VLOOKUP(B2:B15(C2:C15,">=80",B2:B15,"UGRD")(B2:B15,"UGRD"),F9:G12,2)
BUt did not work. Can you please correct me.

 

[Fluff]

Cross posted need help to sove these 2 vlook up problems

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[fahadferoz01]

I am sorry for the action. wont happen again.

But the home work question answer was not answered properly. Am i prohibited to post that and also my effort on that. A lady on chandoo.org said she wants to see what my work is (whether i have tried) or i just want that on my plate. Though she wan not at all helpful I took that as a suggegstion and posted this cause i really need help. Due to covid situaion i can not go out and thought of getting help here. Thats the truth.

Cross posted need help to sove these 2 vlook up problems

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

You are not prohibited from asking questions like this, we just like you to show what you have tried & you have done that.

 

[Fluff]

For question one you will need to use the countifs function.

 

[fahadferoz01]

actually the professor said to use only vlook up function. If you look at the formula I tried using vlook up formula but could not solve it. Will you please look at my formula and rectify it. Or atleast tell me where did I make the mistake?

For question one you will need to use the countifs function.

 

[Fluff]

In that case your professor knows something that I don't.

 

[fahadferoz01]

Great reply. At least now you have also something to learn. Thank me later. Bye.
As a moderator, you can now delete this post.

 

[Fluff]

As a moderator, you can now delete this post.

No, we do not delete threads without good reason.