## Forum Discussion

HansVogelaar

MVP

One option is a lookup list:

The lookup list in the above example is in D2:E7.

The formula in B2 is

=VLOOKUP(A2,$D$2:$E$7,2)

This can be filled or copied downwards.

LDAllen2023

Jul 07, 2023Copper Contributor

Hi Hans,

Thank you very much for responding. I will try thatâ€¦.

Thank you very much for responding. I will try thatâ€¦.