Vba problem
Closed
irum
-
May 17, 2012 at 01:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 24, 2012 at 09:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 24, 2012 at 09:55 AM
Related:
- Vba problem
- Vba case like - Guide
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Vba check if value is in array - Guide
- Vba calculator code - Guide
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 21, 2012 at 10:18 AM
May 21, 2012 at 10:18 AM
Hi Irum,
Sounds to me like you are in need of VLOOKUP.
Let's start with Column E (Lease Rate) of sheet1:
=VLOOKUP(A2,Sheet2!$A$2:$H$100,5)
Make sure you correct the search matrix (Sheet2!$A$2:$H$100) to suit your data.
Drag this formula down to fill out the column.
Apply this formula to the other columns while adjusting the last number in the formula (5) accordingly.
Hopefully I provided enough info to solve your query.
Best regards,
Trowa
Sounds to me like you are in need of VLOOKUP.
Let's start with Column E (Lease Rate) of sheet1:
=VLOOKUP(A2,Sheet2!$A$2:$H$100,5)
Make sure you correct the search matrix (Sheet2!$A$2:$H$100) to suit your data.
Drag this formula down to fill out the column.
Apply this formula to the other columns while adjusting the last number in the formula (5) accordingly.
Hopefully I provided enough info to solve your query.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 22, 2012 at 09:13 AM
May 22, 2012 at 09:13 AM
Hi Irum,
If you don't like the answer then do tell why?, instead of opening another topic.
Best regards,
Trowa
If you don't like the answer then do tell why?, instead of opening another topic.
Best regards,
Trowa
Hi Trowa
I think you mind it.Sorry if it hurts you.Infact I am new in VBA and I really dont know how to explain my question?
Sorry again.
Regards
Irum
I think you mind it.Sorry if it hurts you.Infact I am new in VBA and I really dont know how to explain my question?
Sorry again.
Regards
Irum
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 24, 2012 at 09:55 AM
May 24, 2012 at 09:55 AM
No worries Irum, It seems you are in good hands with Venkat.
Best regards,
Trowa
Best regards,
Trowa
