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.

I would use the VLookup function. Check this website out. And if you still
need help, just let me know.

http://contextures.com/xlFunctions02.html

"Amanda" wrote:

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.

You would normally use a VLOOKUP formula in H3 to do this, but you
will need to give a few more details about your data before I could
suggest a formula. For example, where is the drop-down list, and which
cells are the 207 numbers located in?

Pete

On Dec 11, 6:23*pm, Amanda wrote:
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.

The drop-down list is in G3. And the cells that the 207 #s are in are
C3:C210.



"Pete_UK" wrote:

You would normally use a VLOOKUP formula in H3 to do this, but you
will need to give a few more details about your data before I could
suggest a formula. For example, where is the drop-down list, and which
cells are the 207 numbers located in?

Pete

On Dec 11, 6:23 pm, Amanda wrote:
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.

This is still a bit confusing, Amanda.

If your drop down in G3 is a data validation drop-down, where you have
confined the answers to be only those contained in a list, then the list
would be somewhere else - assume this is B3:B210, so that next to it in
C3:C210 you have the numbers that are associated with those codes.

If this is the case then in H3 you would have this formula:

=VLOOKUP(G3,B$3:C$210,2,0)

Hope this helps.

Pete

"Amanda" wrote in message
...
The drop-down list is in G3. And the cells that the 207 #s are in are
C3:C210.



"Pete_UK" wrote:

You would normally use a VLOOKUP formula in H3 to do this, but you
will need to give a few more details about your data before I could
suggest a formula. For example, where is the drop-down list, and which
cells are the 207 numbers located in?

Pete

On Dec 11, 6:23 pm, Amanda wrote:
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.

This worked perfectly. Thank you so much!

"Pete_UK" wrote:

This is still a bit confusing, Amanda.

If your drop down in G3 is a data validation drop-down, where you have
confined the answers to be only those contained in a list, then the list
would be somewhere else - assume this is B3:B210, so that next to it in
C3:C210 you have the numbers that are associated with those codes.

If this is the case then in H3 you would have this formula:

=VLOOKUP(G3,B$3:C$210,2,0)

Hope this helps.

Pete

"Amanda" wrote in message
...
The drop-down list is in G3. And the cells that the 207 #s are in are
C3:C210.



"Pete_UK" wrote:

You would normally use a VLOOKUP formula in H3 to do this, but you
will need to give a few more details about your data before I could
suggest a formula. For example, where is the drop-down list, and which
cells are the 207 numbers located in?

Pete

On Dec 11, 6:23 pm, Amanda wrote:
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.

You're welcome, Amanda - thanks for feeding back.

Pete

On Dec 12, 2:38*pm, Amanda wrote:
This worked perfectly. *Thank you so much!