Forum Discussion
camusement
Jun 30, 2022Copper Contributor
Auto fill cells in column B depending on drop-down value column A
Hi guys, I need to autofill the values (text input) in column B of my spreadsheet depending on what values (text input) are chosen in column A. Column A uses a drop-down list. To put it more ...
HansVogelaar
Jun 30, 2022MVP
Create a translation table, on the same sheet or on another sheet:
You can use the first column as Source for the data validation drop-down.
Let's say you created the list in A1:B4 on Sheet2.
The formula in B1 on the sheet with the dropdown could be
=IFERROR(VLOOKUP(A2,Sheet2!$A$2:$B$4,2,FALSE),"")
or if you have Microsoft 365 or Office 2021:
=XLOOKUP(A2,Sheet2!$A$2:$A$4,Sheet2!$B$2:$B$3,"")
Fill down as far as you want.