Search : in
By :

Help with excel, formulas

Last answer on Jun 16, 2009 6:41:47 am BST najibk, on Jun 15, 2009 1:55:01 pm BST 
 Report this message to moderators

Hello,

I am trying to connect to sheets together. I need the cells in sheet 2 to equal certain cells in sheet 1. The problem is the data on sheet is horizontal, and the data in sheet 1 is vertical. Furthermore, the data in sheet 1 is separated.

For example, in Sheet 1, you Have the company name in column 1 of a specific row, then different things like Year of inception, and size in each other column.
Now in sheet 2 in have the years 1990-2000 on the top row, and all the companys on the first columns. And I need to insert the companys size at year of inception. For example, if Company X was incepted in 1994, with a size of 45 million, then in sheet 2 i would need to put 45 million where company X and 1994 meet.

But there are hundreds of companies that I need to do this for. Is there any formula I can use?

Is it possible to transpose the date from sheet 1, but only paste it if there is date for it?

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Help with excel, formulas » in :
Basic Excel Formulas Show Basic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Basic Excel Formulas 2 Show Basic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Manipulating Excel comments ShowManipulating Excel comments Associating an explanatory comment to a cell Customizing the format of this comment Associating an explanatory comment to a cell Put your cursor on cell you want to comment. Right-click the cell, then...
How to convert a numeric value into english Word? ShowHow to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
Excel - COUNT # ROWS where 2 conditions are true ShowExcel - COUNT # ROWS where 2 conditions are true Issue Solution Note Issue I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORITY ACTIVE 1 2 Y...
Download Excel Viewer Show
Download Excel-MySQL converter ShowHenceforth with Excel-MySQL Converter, it is not necessary to be a developer to be able to convert Microsoft Excel data into MySQL database or vice versa. This program allows you to convert quickly your data without using other material. Depending...
Ask your question Reply

1

Excelguru, on Jun 15, 2009 3:51:26 pm BST

Hi
Use hlookup(cell address of compnayNameinsheet2(eg A1), rangetolook from companyname to company size(lock the range address),no. of rows between company name and company size in sheet 1, false)

example =Hlookup(A1,Sheet1!$A$1:$B$100,3,false Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

   
Reply to Excelguru

2

najibk, on Jun 15, 2009 5:47:07 pm BST

Hi
Thanks for the help, but its a little more complicated than that.

Can I send you the excel sheet so I can explain it better?
Thanks

   
Reply to najibk

3

 Excelguru, on Jun 16, 2009 6:41:47 am BST

Hi

you can make an If statement to check the year of inception (use hlookup to pick the year of inception) and for the Yes portion of if statement, use another hlookup to pick the company size and for the false part put an "".
If any further complications are there, Just type the complications... Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru
Ask your question Reply
They need your help