View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default vlookup help with two of the same lookups

Hi,

I need a little help. Below is a report that I dump in Excel. You will
note that both classifications have an €˜other option. How do I write a
formula that will skip classification if I want the total number of File
Breakdown €˜other and vise versa.

I have been using a vlookup.

Thanks


Classification Breakdown
Product Information 89
Issues 69
Return Information 38
Other 30
Order Status 24
Shipping Information 9
Website 2
Payment/Billing 2
File Breakdown
Deleted 220
Vendors 4
Mailing Responses 3
Other 1
Spam 1
Wholesale 1