rdoulaghsingh
Board Regular
- Joined
- Feb 14, 2021
- Messages
- 105
- Office Version
- 365
- Platform
- Windows
Good evening. I'm looking for a formula that will read the input from a dropdown list and if the text selected from the dropdown list equals one of the words from a range of cells on another sheet, then input the cell value of the cell immediately to the right of the text.
So basically, If cell A1 equals 'C' then read from 'sheet1' cell range A1-A26 and when C is found in the range take the value to the cell to the right (in this case 'B3) and make that the cell value with the formula.
Is this possible?
Thanks!
So basically, If cell A1 equals 'C' then read from 'sheet1' cell range A1-A26 and when C is found in the range take the value to the cell to the right (in this case 'B3) and make that the cell value with the formula.
Is this possible?
Thanks!