vlookup column reference

  1. J

    Need help with Excel formula to find a group of data and return a value in that data set.

    I have a fairly large spreadsheet with about 5,000 lines and 100+ columns. I've taken a small piece of it and posted below to give you the layout of the spreadsheet. Row 2 is a number assigned to each month over the next 10 years. What I'm trying to do is write a formula that will look...
  2. J

    how to get the number of times, average of times, and last occurrence when a value repeats consecutively

    The setup A1 S S S D D S S S D D D D A1 is the column I get my values from B1 would be a helper column that's numeric B1 1 2 3 4 5 6 7 8 9 10 11 12 I need a formula that will tell me how many times the S REPEATED 3 times REFERENCE TO B1 the average time of the occurrence, and the...
  3. V

    Vlookup- multiple values

    The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one... This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the...
  4. M

    Funcion / Formula / Macro

    Buenas, Super Colegas, de los que admiro por tanto conocimiento... Mi necesidad es con una funcion o formula en Excel... detallo: Hoja1 tengo un rango de celdas que son nombres de la columna de B2:B200 necesito buscar los mismos nombres que sean iguales de la Hoja2 con el mismo rango de...
  5. badinvestor

    vlookup w/array in another sheet??

    i've looked all over the other threads and can't quite find what i need. i need to find a value where the lookup_value is on the the same sheet that contains the formula but the array etc. are on sheet 2. e.g. sheet 1 has two cols. col1 contains a ref # and col2 needs to return the value from...
  6. H

    Cross referance chart formula help

    Hello Experts, I have been working on theis cross referance formula for a while. I now need some help. I may be close but not close enough. This chart is used for a HVAC application. 51 is wet bulb temp, 71 is dry bulb temp, the cross referance would be 21.3. <TABLE style="WIDTH: 147pt...
  7. D

    Vlookup problems

    Hi there, I am new to using Vlookup (and in fact more complex excel formula). I am producing a door schedule at an architects practice. I have set up a sheet within the excel file that has a generic door type code with additional information across several columns. I want to transfer the data...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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