avinashraste
Board Regular
- Joined
- Mar 12, 2008
- Messages
- 167
Dear all,
I have a question about a formula. I have an excel sheet having a list of 180 names. All the names has a specific value. For eg. abc - 500, xyz - 700, jkl - 200 and so on.
This list of names & values are in Sheet 1, and I want a formula to work in Sheet 2. The moment I write the name, the next cell will automatically show the corresponding value which is there in Sheet 1. For eg. if in Sheet 2, I write abc in cell A1, the cell B1 will be filled by the value 500.
PLease guide & help
Thanks & Regards
Avinash Raste
I have a question about a formula. I have an excel sheet having a list of 180 names. All the names has a specific value. For eg. abc - 500, xyz - 700, jkl - 200 and so on.
This list of names & values are in Sheet 1, and I want a formula to work in Sheet 2. The moment I write the name, the next cell will automatically show the corresponding value which is there in Sheet 1. For eg. if in Sheet 2, I write abc in cell A1, the cell B1 will be filled by the value 500.
PLease guide & help
Thanks & Regards
Avinash Raste