Combobox select add values in other column in new cell
Closed
exceluser123
Posts
1
Registration date
Tuesday November 28, 2017
Status
Member
Last seen
November 28, 2017
-
Updated on Nov 28, 2017 at 02:20 PM
Blocked Profile - Nov 28, 2017 at 04:54 PM
Blocked Profile - Nov 28, 2017 at 04:54 PM
Related:
- Combobox select add values in other column in new cell
- Pdf and xps add in 2007 - Download - Other
- How to add @ in laptop - Guide
- Vba select case like - Guide
- Add accent over e - Guide
- How to add watermark in word - Guide
1 response
So bounce the selected value against a vlookup from the same index you are populating the combobox. In other words, sheet1 has the following:
columA(item)----------columB(value)
1. apple(item)------------5(value)
2. orange(item)-----------6(value)
The combo box gets its values from range A1:A2. The combobox places the selected value into D1.
Now, do a vlookup against the posted value. So, if your combobox places the value of apple into cell D1 then the vlookup formula would be as follows:
=vlookup(D1,A1:B2,2,false)
This says:
Lookup on range A1:B2 for the value in cell D1, and dont worry about matching the value exaclty (false).
I hope this helps.
Have FUN!
columA(item)----------columB(value)
1. apple(item)------------5(value)
2. orange(item)-----------6(value)
The combo box gets its values from range A1:A2. The combobox places the selected value into D1.
Now, do a vlookup against the posted value. So, if your combobox places the value of apple into cell D1 then the vlookup formula would be as follows:
=vlookup(D1,A1:B2,2,false)
This says:
Lookup on range A1:B2 for the value in cell D1, and dont worry about matching the value exaclty (false).
I hope this helps.
Have FUN!
