vlook

Hi friends, I am trying to create set of macro functions for my work. part of macro i need countif function in sheet 1 sheet 1 A column L Column Part Number Countif N8081159 5 N8081159 5 N8081159 5 N8081159 5 N8081159 5 N2080649 4 N2080649 4 N2080649 4 N2080649 4 G3070199 3...

Hi, I have 2 Excel files Summary and Updated Summary. In Summary file there are A & B columns and in the Updated summary file also there are 2 columns A & B. In Column A of Summary file there is a Unique ID and the status for that ID is there for few ids and the status of few Ids is blank. In...

Looking at the headers below I want to build a look up formula that will result in the latest (most recent date in list) transaction date (A) for a specific transaction type (B) for the MedID (D) for Station (E) and return the associated information in the desired results format listed below the...

Hi everyone :biggrin:, Here's my problem i have an excel sheet with appoxiamtely 13,000 entries and i need to compare 2 columns versus two other columns within the same excel sheet by looking for the same entry. So i want to have something that will look at the name in Column H and then look...

I am using vlookup to get the values from another workbook. Is it possible: i use 2 Lookup_value & fetch the matching values. In workbook1: I want to Lookup_value A1 with another workbook2 AND ALSO Lookup_value B! with workbook2 & then fetch a vaue lying in the 20 column (Colm_index_num). How...

<table style="width: 497pt; border-collapse: collapse;" x:str="" border="0" cellpadding="0" cellspacing="0" width="658"><colgroup><col style="width: 18pt;" width="24"><col style="width: 37pt;" width="49"><col style="width: 43pt;" width="57"><col style="width: 41pt;" span="2" width="54"><col...

I want to type in a customer name in A1 and have a dropdown list in B1 be populated with possible shipping addresses. would i use a vlookup connected to the drop down in some manner? The goal is to type in a name, select an address, and then print out the sheet to use as a shipping slip. Is this...