Vlookup Help

Computing.Net > Forums > Office Software > Vlookup Help

Original Message

Name: Randymac
Date: February 21, 2005 at 14:22:02 Pacific
Subject: Vlookup Help
OS: XP
CPU/Ram: pentium

Comment:

I want to know if any of you have a formula that will allow me to use vlookup to return a total count of the entries that fit the vlookup criteria.
For Instance:
I have a sheet that has multiple names along with case numbers and another column that shoues is the case was closed or open.
I then have a summary sheet in which I want it to seach through and find all cases that have the same name and return the closed cases. Then I want it to return the all the open cases for that username.
The data sheet will continually change so I want to be able to past a new sheet in and the formulas will calcualte the correct information.
Can anyone help?

Report Offensive Message For Removal

Response Number 1

Name: chnos
Date: February 21, 2005 at 22:52:05 Pacific

Reply: (edit)

i think a pivot table should be quicker . It can be done on several sheets.

Report Offensive Follow Up For Removal


help with VLookup Macro vlookup / hlookup help Excel Nested IF/Vlookup Date matching using VLOOKUP Excel formula help	Excel 2003 Formula HELP VLOOKUP tables Excel Formula, need help! SUMIF or VLOOKUP? a range of cells Excel Function (Vlookup)

MS Excel tab key

Nod32 and Outlook

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Vlookup Help

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 6 Days.
Discuss in The Lounge

DVD-ROM Problems

Reverse Proxy

Help setting up Apache and PHP

DVD Menus in Windows Movie Maker

After installin SP3, NTDLR not foun

All Posts Awaiting Replies