excel 2010 vlookup issue

Posted on 2011-10-05
Medium Priority
Last Modified: 2012-05-12
Can you help with this issue. I am trying to learn how to do this as I have a work project covering the same concepts (vlookup, countif, and scenario summaries). It is case 1. Attached is the excel file. the directions. I have a huge project that I am working on currently that is due tomorrow.

Question by:StaffordGroup
  • 2
LVL 42

Expert Comment

ID: 36922290
This looks like homework.

Here's a handy reference manual on how to use VLOOKUP:


You can search contextures for COUNTIF and other functions as well.

For a basic "what does the formula look like and what does it do?" you can also reference Excel help.

Good luck!

LVL 42

Accepted Solution

dlmille earned 1500 total points
ID: 36922298
it also appears, if you read the pages, there are plenty of hints in how to solve the problem in Excel.

Give it a shot & again, good luck!


Author Closing Comment

ID: 36922320
thanks for the reference material. I think I got it.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question