Help with excel, formulas
Closed
najibk
-
Jun 15, 2009 at 08:55 AM
Excelguru
Excelguru
- Posts
- 261
- Registration date
- Saturday April 11, 2009
- Status
- Member
- Last seen
- June 21, 2011
Related:
- Help with excel, formulas
- Excel @ in formula ✓ - Forum - Excel
- How to copy data from one sheet to another in excel using formula - Guide
- How to insert picture in excel using formula - Guide
- Excel position formula ✓ - Forum - Office Software
- How to change date format in excel using formula - Guide
3 replies
Excelguru
Jun 15, 2009 at 10:51 AM
- Posts
- 261
- Registration date
- Saturday April 11, 2009
- Status
- Member
- Last seen
- June 21, 2011
Jun 15, 2009 at 10:51 AM
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
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
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
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
Jun 16, 2009 at 01:41 AM
- Posts
- 261
- Registration date
- Saturday April 11, 2009
- Status
- Member
- Last seen
- June 21, 2011
Jun 16, 2009 at 01:41 AM
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...
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...