look up multiple values

  1. G

    INDEX and MATCH formula

    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...
  2. M

    Vlookup...Hlookup...Index/Match...help!!!

    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...
  3. K

    Multiple value lookup & sum

    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...
  4. D

    New Sheet need help on Lookup on two sheets is possible

    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...
  5. P

    Dynamic Formula (repeating the formula)

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

    Lookup multiple values

    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...
  7. G

    Lookup/ Index/ Match question

    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...
  8. A

    Excel formula help needed please!

    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>...
  9. J

    Help with looking up item price

    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...
  10. H

    Lookup retrieving multiple values

    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!
  11. E

    Duplicate look value

    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...
  12. W

    lookup table

    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...
  13. C

    Require data from multiple columns using 2 spreadsheets

    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...
  14. B

    Copy (range} from worsheets to "Results" sheet

    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...
  15. D

    Automation Help - (10 Years of not using Excel, Kill me Now)

    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...
  16. A

    Lookup number value in cell with multiple values and ranges

    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...
  17. C

    Data analysis question

    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"...
  18. T

    Help with formula to "FIND" numbers within a cell that contains other numbers

    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)...
  19. E

    Summing/Averaging Data for individual days

    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...
  20. B

    Lookup of Two Variables In a Table

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top