vlookup column reference

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

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

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

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

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

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

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