lookup multiple values

  1. P

    Assistance required

    Hello all. I don't have very much experience with Excel but I am really trying to do my best. I am working on a small project and thought that Excel would fit the bill. I have run into a little snag (brain freeze). Here are some details. A friend, who has a small courier company, has asked me...
  2. S

    Only Return Values that Start with a Specific Letter

    I found the following awesome script on digital-help.com that allows me to lookup and return multiple values concatenated into one cell (which I need to do): Function Lookup_concat(Search_string As String, _ Search_in_col As Range, Return_val_col As Range) Dim i As Long Dim result As String...
  3. C

    Return fixed value if one of several variables matches the values in a row

    Hi, I am trying to create a formula that will allow me to look up three numbers in a row and if those numbers match the value in the row, then return a fixed value. Values that need to be looked up: 1, 3, 5 Row 1: containing numbers from 1 to 10 Value in Row 2 (in same column), if any...
  4. S

    lookup multiple values in a cell and return true/false

    Hi - I have a sheet with a column containing a Group name and another column with multiple group member ids in each cell separated with % symbol. For eg: A1 = Group A B1 = 34543%456456%23475 I have another sheet that has group member ids, however they are not of the same order as sheet 1...
  5. C

    Look up multiple values and return multiple corresponding values

    Hi, I know how to return multiple corresponding values from a list based on one value, however now I am trying to return all the corresponding values from a list based on multiple values. My original code is as follows: =INDEX('FIC Info'!$A$1:$P$512,SMALL(IF('FIC...
  6. N

    lookup, single criteria, multiple sheets, multiple results.

    someone please put me out of my misery. i have finally broken down after 5 hours of struggle and decided to ask for help. this is the situation. sheet 1 <tbody> Case date name product price A 10-oct john mobile 1000 B 15-oct mark tv 1500 </tbody> sheet 2 <tbody> case date name...
  7. K

    Need to return multiple values based upon multiple criteria

    I'm not sure if Excel or Access is the best tool. I am seeking to search for roughly 1,000 unique search strings amongst 100,000 customers and identify all string matches. The customer data set consists of customer ID (column A) and customer name (column B). I would like to return all...
  8. B

    Lookup - but with two criteria

    In deperate need of some help here.. I have a worksheet with data set out as follows (the slimmed down version and rates just jotted in): RefCcy SecCcy FX Rate GBP GBP 1.0 EUR EUR 1.0 GBP EUR 0.8 EUR GBP 1.4 EUR USD...

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