# vlookup column reference

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

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

### Which adblocker are you using?

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

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