vlookup and lookup value

  1. M

    Please Help!! Duplicate values with multi. quantities, Vlookup? Something else?

    Need help… Vlookup will only being the first instance back with duplicate valves. In my case I am looking a large amount of part numbers and bring the quantity back. Many of the part numbers repeat with different quantities, with vlookup it only brings the first instance of the part numbers...
    • Mke49048
    • Thread
    • duplicate data index & match index and match mulitple instances vlookup and lookup value
    • Replies: 1
    • Forum: Excel Questions
  2. E

    Returning Photo Value with a vlookup where drop down menu isn't an option

    Hello, I have a very complex schedule that I would like to set up in excel. We have aprox. 100 classes per week, the time slots for these classes vary, as do the instructors and classes for these time slots. I set up how I want the schedule to look, but I am seriously struggling with how to...
  3. R

    VLOOKUP using the results of a formula as LOOKUP VALUE

    I have a cell that I must remove the first 2 characters "RO" for each value in a column on a sheet called RAW DATA and put into a cell on a sheet called ROSS DATA. Some of the values in that cell have 3 digits after the RO and some have 5 digits. To do that I used =REPLACE('RAW...

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