Reply to thread

Message

[QUOTE="Gord Dibben, post: 3840757"]
You want when you select 01 that Swimwear appears in the same cell?

Select 02 and Jackets appears in the cell?

You can do that with event code and a lookup table.

Create the lookup table first.

Then create the dropdown in A1

Now insert the code below to the sheet module by right-click on the sheet
tab and "View Code".

Copy/Paste into that module................Edit to suit then Alt + q to
return to Excel.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Vals As Range
Dim R As Range
Dim RR As Range

Set R = Me.Range("A1")   'DV dropdown cell
Set Vals = Me.Range("P1:Q100")  'lookup table

'column P is list range for DV dropdown
'column Q has list of return numbers
'these could be on another worksheet

'Set Vals = Sheets("Sheet3").Range("P1:Q100")

If Intersect(Target, R) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False

On Error Resume Next

For Each RR In Intersect(Target, R)  'Only check changed cells
RR = Application.VLookup(RR.Value, Vals, 2, False)
Next RR
endit:
Application.EnableEvents = True

End Sub

Gord
[/QUOTE]

Verification