I am trying to find a formula that can autofill H3 when G3 is a certain value
picked from a drop-down list. For example: I picked 52109706AB from a
drop-down list in G3. I need H3 to auto-populate with 1452-AA. However, G3
might not always be 52109706AB. It might be one of the 207 numbers within
the drop-down list, so then H3 would auto-populate with the corresponding
number, using the data within the drop-down list. I hope this makes sense,
and I hope that someone out there can help me.