lookup array

  1. M

    using lookup formula

    Hi, Just wondering if anyone could figure how I can do the following: I have 2 columns below, One named School and the other one called Area. My formula in the school column is: =LOOKUP($B7,{"management","hairdressing","medicine"},{"Management School","Hairdressing School","have to do further...
  2. J

    Array search

    Hi! I'm trying to write a function for each item in a list to compare if it's in an array, and then write Yes or No, in the box next to the name. The hard part is the names don't line up perfectly. I have a table that looks like this... <tbody> Last Name Vote? Smith Johnson Jones...
  3. R

    Match Function with Array as Lookup Value

    Hi, I have some data that looks like this: (Sheet1) Crew Day1 CR1 5 CR1 2 CR2 3 CR5 1 (Sheet2 Array) CrwMkp B C D CR1 1 3 1 CR2 2 1 1 CR3 5 0 0 CR4 6 2 3 CR5 0 1 0 What I am trying to do is to look through...
  4. J

    Range Lookup

    Hi Everyone How can I lookup the following: Calls £ 1-5 2.50 6-10 2.00 10+ 1.75 For example, if I make 7 calls it will cost £2.00. How formula can I use to look up and give me the answer? Many thanks Johnny
  5. T

    Lookup Value in Combo Box and Return Multiple Lookup Matches

    OK - here is what I want to do - in the attached spreadsheet I want to lookup the numeric value in the drop down list (under the label Project ID & Name) on Dashboard Page - but prefix it with PP and then use it to lookup all matching rows in sheet ImpactDetails and return the Asset ID and Asset...
  6. R

    Using Match function with dynamic reference (llookup array)

    I want to use a dynamic look up array with match and have the below example: =MATCH(B$4,CONCATENATE("'",A5,"'!$E:$E"),0) The above formula result is #VALUE! Cell A5 has the value Sheet1, however, after testing this will change to a date e.g. 01-Jul-14 What am I doing wrong? I am going to use it...
  7. B

    Summing values from different tables

    Hello, This is my first post on Mr. Excel and thanks beforehand for any help you can give! My problem is as follows: I am working on a workbook to keep track of individual projects in a company. Each project has its own worksheet. In each worksheet I have a chart estimating labor in distinct...
  8. M

    Help with a cost calculator based on different options.

    Hi, I am trying to compile a calculator based on a set of options selected by the user. I want to use validation to allow a list of 3 choices which then determines what further options are available. This is the table. <TBODY> Area 1</SPAN> Area 2</SPAN> Area 3</SPAN> 0-2 & TS</SPAN> 3-4...
  9. Q

    Return cells below lookup value

    Hi everyone I'm having a probleming with following: In the following excel table i would like to extract the Materials that belong to certain Models. E.g: <colgroup><col><col></colgroup><tbody> Models Materials 1012555 1012555 1012556 1012555001 1012557 1012555002 1012558 1012555003...
  10. D

    SUMPRODUCT with INDEX & MATCH

    Hi, I have a list of sales data for a range of products sorted with respective attributes such as flavour, filling size, etc. These products (drinks) are normally packaged by unique flavour which makes counting sales units by flavour very easy by simply specifying the criteria in either...
  11. S

    Best way to lookup payroll records

    Each payweek I receive about 600 records some with duplicat names if an ee works overtime. I then look at previous payroll and extract a given account code. Because some ee's work overtime the rows do not always synchronize in count or names. Any suggestions on the BEST lookup function? Or...
  12. F

    In NEED of a Vertical Lookup to remove duplicates and return unique values horizontally!!

    Hi All- I can't seem to figure this one out.. here are the details of the data I am looking to reorganize: In column CT between rows 11:210 is the vertical data that includes duplicates. I am looking to create a formula that can lookup each value between CT11:CT210 and return only the unique...
  13. P

    populating a full list of all like (tyres)

    I am trying to create a spreadsheet the will populate/pull all tyre sizes that I have collected from different suppliers. <colgroup><col><col><col><col><col></colgroup><tbody> Tyre Size 165/80 R13 Size Brand Cost Price Selling Price Supplier </tbody> Cannt...
  14. M

    Search for multiple text and return multiple values

    So I have column S in which each cell has a description of a sport program like "Coed 5v5 New Years Soccer Challenge" and I want to create a new column AE that searches column S for a list of key sports words from column AG "Soccer","Volleyball",etc. When we find "Soccer" or "Volleyball" in...
  15. A

    Help with lookup

    Dear all I need to search several folders for a match on names taken from a namelist, and then display the department name of the folde the name was found in. Namelist <tbody> Name Department Tina Kim Lars Bo </tbody> Sheet 1 (value listed in A1 is department) <tbody> JUR...

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
Back
Top