Forum Discussion
Excel formulas
Hi there, I would like to populate a cell, based on the values that are chosen from the previous two cells, which are drop down lists. For example Column 1 - ''Ten'' is chosen, Column 2, ''Bl...
| A | B | C | |
| 1 | test4 | four | orange |
| 2 | test5 | five | white |
| 3 | test8 | eight | green |
| 4 | test7 | seven | orange |
| 5 | test9 | nine | silver |
| 6 | car | ten | black |
| 7 | test6 | six | green |
| 8 | test2 | two | green |
| 9 | test3 | three | orange |
| 10 | test1 | one | green |
If the data preset is like above, than your target function will be :
=XLOOKUP($I$3&$J$3,$C$2:$C$11&$D$2:$D$11,$B$2:$B$11,"NA",0)