Forum Discussion
Drop down list
Hi all, How do you create a condition in Excel that if I selected a figure in one column from a drop-down list, then in the next column an automatic figure will appear that is associated with a...
Anhen1380 That would be with one of Excel's ways to lookup data.
Use functions like LOOKUP, VLOOKUP, HLOOKUP, INDEX and MATCH, XLOOKUP for instance. Which one to use depends on the underlying data and/or Excel version you are using.
Thanks.. I'll try it