'IF vlookup returns exact match, then activate and select from a 'list'

**andrew@ilguk.com** · 05-08-2013, 08:19 AM

If anyone can help with this I would be most grateful and would provide the necessary detail.

**ChemistB** · 05-08-2013, 08:41 AM

You need to give more detail. Do you want this list selection in the same cell?
If you are talking about the vlookup in say A2 and the list option in B2, then you can use Dependent Data Validation as described here

http://www.contextures.com/xlDataVal02.html

**andrew@ilguk.com** · 05-08-2013, 08:53 AM

ok thanks for swift reply - appreciated
sheet1
column A1:A10000 contains company name details
column B1:B10000 contains 1st contact details
column C1:C10000 contains 2nd contact details and so on through D:G
column F1:F10000 contains a numeric code assigned to each entry in A1:A10000

I created a list to make the drop down selection for A1:A100000 (column G) and the NEXT column F needs a VLOOKUP (or suggestions) that looks at matching the record entry from G: in A: and then in the same function allows/provides me with a selection/list from B:G:

**ChemistB** · 05-08-2013, 09:19 AM

Something like this? (See attachment)
With the lookup list for A:A in G1
With the selected cell H1, go to Defined Name (i.e. List)
=INDEX(Sheet1!$B$1:$E$5,MATCH(G1,Sheet1!$A$1:$A$5,0),)

Then in H1
Data Validation > List> = List (or whatever name you defined)