Forum Discussion
Need Formula help with pulling value from a list
Hey, So I am trying to figure out a way to get a value to auto populate based on the value in another cell. Here is what I looking for. I have made lists which have the names(column A) and values...
=VLOOKUP(C2,$A$2:$B$4,2,FALSE)=INDEX($B$2:$B$4,MATCH(C2,$A$2:$A$4,0))You can apply these formulas.
Could I do that for an entire column where each cell could be different? Basically Column C and Column D would continue for 80-100 cells.
=IFERROR(VLOOKUP(C2,$A$2:$B$6,2,FALSE),"")You can fill the formula down as required. And you can add data in columns A and B as well. If there is a user input in column C that is missing in column A you can add IFERROR in order to return e.g. an empty cell instead of an error. In the example the input from cell C10 isn't found in column A and the IFERROR returns an empty cell in D10.