Help with excel, formulasClosed

Question

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?

Excelguru · Answer

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

najibk · Answer

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

Excelguru · Answer

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

Help with excel, formulas

3 replies

Subscribe To Our Newsletter!