How-To Autofill cell if cell beside it is a certain value

A

Amanda

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.
 
P

Pete_UK

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
 
P

Pete_UK

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
 
A

Amanda

This worked perfectly. Thank you so much!

Pete_UK said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change drop down list in one cell based on values in other cells 2
Copy, Paste Special Value 1
vlookup or index match??? 5
Drop down lists and autofill 3
Changing a cell value from another cell. 2
list cell problems...... 1
Best method to populate cell based upon drop down list selection 4
Excel Excel: How do I put a formula in a drop down list 11

Top