Put the following formula in Cell H11 and fill it over to I11

=$A$1&VLOOKUP(H10,$B$4:$D$10,2,FALSE)&VLOOKUP(H10, $B$4:$D$10,3,FALSE)

Then without changing the active sheet run the following procedure

Sub TestVlook()
Dim wb As Workbook, ws As Worksheet
Set wb = ThisWorkbook
Set ws = wb.ActiveSheet
Workbooks.Open Filename:=Range("h11").Value
ws.Activate
On Error Resume Next
If Not Range("i11").Value = "#N/A!" Then Workbooks.Open _
Filename:=Range("i11").Value
End Sub

The above formula does not have error trapping to take care of the
situation in which H10 doesn't have in it a value that is included in B4:B10

Alan Beban

Loz wrote:
Hi everyone,
Sorry I didn't reply earlier (it's 10am in Sydney atm and
I've just logged on...)
This is what I was trying to achieve:

A
1 c:\files\ (DropDown1 of B3:B10)
2 (DropDown2 of B3:B10)
A B c D
3 Ibm IBM FAStT700 IBM\ ibm.xls
4 Dell EMC CX600 DEL\ dell.xls


DropDown1 puts selection into cell H10
DropDown2 puts selection into cell I10 (if one was
selected)

Then I wanted the code to find H10 in B3:B10 and open the
file Ie. IBM FAStT700 selected and then opens A1 & C3 & D3

Then IF I10 was populated with another option ie EMC CX600
it would then open that file.

I am really sorry if I was unclear (or still am) maybe I
am going about it all wrong?!?!?! I am just plodding along
and trying to achieve the best i can :-)

Thank you for your support!
I will also try the examples provided today thanks

Kind regards,
Lauren