look up multiple values

I need help creating a formula to look up values in order in the rank column in the table on the right, and pullover the Group A country onto the table to the left. The idea is that I hide the table to the right that is calculating scores based on another area in my spreadsheet, and I will use...

I have tried them all to no avail. I am looking to perform a type of lookup. On Tab “Sheet1” I have raw data, each name has 3 rows. I need to find a specific row based: Matching Name from sheet2 to sheet1 and where the Type is “Date”. From that identified row, I want to put the dates in the...

Hello all. I'm creating a machine capacity file in Excel, counting the total hours available and deduct some loss of hours. However I'm having trouble finding a correct formula to make a lookup in a 2d table, getting back 1 value which combines the values of multiple fields. Simplified, my data...

Hello Guys Need some help please not sure if it is possible but i think it may be. I am knocking together a new SS covering Stock on two separate sheets (they need to be several different fields but some the same) I have a sales sheet A1 i want to add a SKU number in which i want Excel to...

I would like to repeat a formula and make its dynamic depending on the request. The formular that I would like to repeat is...

Hi, I have a list of ID's but in the same list there are duplicates, then I have my consolidation sheet without any duplicates, my issue is that I need to have the contents of a different column for each of the ID's. Data sheet example Column A (ID) | Column D (Result) 1111...

Hi -- I am trying to write a formula that will return to me a % based on a given age and height. Starting in cell D4 I have this: <tbody> <1% 1% 3% 5% 10% 25% 30% 50% 75% 0 30.5 31.5 32.5 33.5 34.5 35.5 36 36.5 37 1 31.5 32.5 33.5 34.5 35.5 36.5 36.75 37.25 38 2 31.75 32 32.25 33...

Hi all, I have been given a task to transfer some data from one spreadsheet to another, but I'm struggling to find a formula to help with it... The data I have to transfer is in the following format: <TBODY> Server Name</SPAN> IP Address</SPAN> Area</SPAN> Server A</SPAN> 1.1.1.1</SPAN>...

hi all, i have one sheet with items & set pricing. ------------------------- A B C D E items itemcode price1 price2 price 3 etc... prod1 PR1 29.99 27.95 prod2 PR2 35.99 31.99 prod3 PR3...

Hi! I am trying to use a lookup to find the quantity of a certain fabric. However, more than one style uses the same type of fabric. Is there a way to do a lookup that retrieves multiple values? Any help would be greatly appreciated! Thanks!

Hi all, Sometimes i run into duplicate look value in financial statements. Look value <table style="padding-right: 2pt; padding-left: 2pt; font-size: 11pt; font-family: Calibri,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"><tbody> <tr...

Hello, I am trying to do a look up table or if you have another tip go ahead and give it to me. I have a table with number 121 253 215 95 125 12 I have range 0-100 --> A 101 - 200 --> B 201 - 300 --> C What I want from on table next cell it should get the grade like 121 >> B 253...

Hi all I need your help! I have 2 spreadsheets in the same file and need to take some data from Sheet 1 into sheet 2 based on 2 columns of critieria: Sheet 1 contains: Employee Date Location Smith John 21/02/2011 London Doe, John 03/01/2011 Birmingham Bloggs, Joe...

Windows 7<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Excel 2007<o:p></o:p> <o:p></o:p> PROBLEM: I have completed my loop through all the sheets in my workbook. All my data is copied to a “Results” sheet that looks like this. Player 1 has been copied...

I have finally gone back to work after a severe car accident. So 10 years later I have forgotten much and much has changed. Please refer me to the best books, tutorials or training information. I need to become an Excel Wizard in my new position. I will do the work. I need help on this...

I am trying to take a column of values that represent grades at particular schools. The possible values are P, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12. I want to take the values in each cell and move them to separate columns of P, K, 1, etc. However, the values listed in the cells vary, i.e...

I have a spread sheet with shares data in, using a 30 min period. ie Open, High, Low, Close for each 30 min period in a day. columns are laid out in like this Date Time Open High Low Close <table style="border-collapse: collapse;" width="469" border="0" cellpadding="0"...

Hello guys! How is it going? I'm looking for your precious help again with a formula to "Find" some characters. I hope you could guide me through... Here is what I need to do: - I have a database with cells that contains a series of "names" within each cell... I need to sort (alphabetically)...

Hello! I have a huge amount of weather data that I am trying to summarize by day. In one column I have the day/time stamp (30 minute increments) and in the second column I have the total rainfall for that period. I want to sum the rainfall quantities by day. Any ideas? 2nd Question In one...

Hi, I want to look up two variables (discipline and grade) and return the corresponding rate. Elsewhere in the spreadsheet I'm using drop down (data validation) cells to select adiscipline and then a grade and I want the lookup function to automatically return the rate associated with that...