Ok, title may be slightly confusing, but here's my situation;
-I have a notepad doc that is a data dump of information. Each "entry" is represented in four vertical lines.
Ex)
Info Line 1
Info Line 2
Info Line 3
Info Line 4
Info Line 1
Info Line 2
Info Line 3
Info Line 4
(each entry separated)
What I'm looking to do is get this information into excel so that all four lines of each entry are on a Single row in excel.
Info Line 1 Info Line 2 Info Line 3 ....
Info Line 1 Info Line 2 ....
This is a LARGE data dump, so I'm looking for an efficient way to accomplish this, and I am drawing a blank.
Any help would be greatly appreciated. Thank you so much in advance!
Hi, my first post on this great forum that has provided lots of useful information to me in the past.
I would like to do a two way lookup, except that the horizontal lookup is not within a fixed row, it needs to be within the row returned by the vertical lookup.
E.g. I have a range A1:Z10. I must search within A:A for ValueY. ValueY is found in A4. I would then like to search for ValueX only in 4:4
Can someone suggest a formula solution?
Many thanks in advance.
Hi All,
I am trying to import a BASE ESTIMATE table into EXCEL.
I have problems with most of the formulas, especially this one:
=VLOOKUP($E$2,$B$24:$P$604,HLOOKUP($E$3,$D$22:$L$604,1)+2)*HLOOKUP(HLOOKUP($E$3,$D$22:$L$604,1),$D$2 2:$L$23,2)
and this one
=ROUND((IF(AND(OR(E7>E5,E7>E6),E3<40000),E7,IF(AND(E6<E5,E3<40000),E6,E5)))*E8*1.055*1.06,2)+10
I am not sure if EXCEL allows a HLOOKUP within an HLOOKUP. If not, how can I get around this?
Thank you so much in advance!
Hi Board,
I have a sheet with multiple rows of data. I need a formula to look through the row and return the maximum value. I tried the Max function, but it only works vertically. Any ideas?
Thanks in advance,
Jill
OK, so I have a number of coloums with figures.
What I want to say is:
If the column is not 0 but is a number (1,2,3...) then look to the column heading and display that heading.
Is that possible? Do I need a lookup for that one?
Hi, I have data's(All text) from Column A to Column G and I need a formula which lookup ColA, ColB, Row1 and gives output
ColA ColB ColC ColD ColE ColF ColG
Scenario Op NC FO FI CP Past
What is.. ABC kjha ert sd fgh fg
What is.. XYZ qwer ert df fgh aw
What is.. MNO er rt ter er
What is.. EFG ert er ghj ytry
You have.. ABC
You have.. XYZ
You have.. MNO
You have.. EFG
Where.. ABC
Where.. XYZ
Where.. MNO
Where.. EFG
I have the following spreadsheet:
A B C D
1 Jan Feb
2 blue 50 30
3 red 125 544
4 yellow 40 44
5 blue 30 122
6 red 54 60
7 red 100 80
How do I use sumproduct with a lookup in the colums. For ex. I want to know
how much I have in the blue for Jan and Feb. I don't won't to use pivot
tables.
Thanks Gingit.
Hi Guys,
I have few data which consists of Vertical and horizontal headings with values. These vertical and horizontal headings may vary its position but I need the correct value from the main sheet.
State Not So Good General Good
Mumbai 51 36 74
Dehi 33 27 46
Kerala 35 24 73
AP 34 27 46
Karnataka 56 24 78
Chennai 23 26 54
Kolkata 48 36 76
Gujarat 64 42 43
The above details will be the main sheet which may vary the horizontal and vertical headings.
IN the next sheet I will have some fixed headings which should pull the data from main.
Any help would be appreciated.
With a vertical lookup I am referencing a cell in a column and looking across the same row to find a value. In this case I want to reference a cell at the top of a column and look down the same colum to find the values needed.
In other words if I have 3 columns with headers "A" , "B" and "C"
and 4 rows A1 = last Name , A2 = First Name , A3= Age , A4 =sex
How do I generate the list
First Name John
Last Name Jordan
Age 50
Sex Male
I tried the Colo add in but I am getting a macro security error.
Hi I want to look up accross cells then when a match is found look down that column.
I tried this =SUMPRODUCT(--('00042'!A7:F7="June"),SUMPRODUCT('00042'!H1:H1000=Formulas!A5),('00042'!E1:E1000))
no luck as sumproducts want the look up range to be the same size. Column E needs to be a variable as not all sheets have the exact same format and I want to pull the value from the column with the header "June". The header will always be on row 7.
Any help is great!
