Get textBox Value by searching cells

[colmguckian]

I have a userForm which is part of Workbook1
On the User form there are 3No. ComboBoxes and 1 No. TextBox.
The RowSource in each ComboBox Depends upon the selection in the preceeding ComboBox.

I also have a workbook2 Which has rows with Headings in Red Font
The sub headings are in the rows directly underneath in the same Column in Black Font. These rows are followed by another headed row in Red Font,
Which is followed by more sub headings in black Font etc etc.....
The Sub heading have Associated Prices which are located two Colums Over.

Once the final Value is selected in my userform for ComboBox3
I am looking for a code that will search all the cells with red Font in Column1 and Column4 in sheet1 of workbook2 For the best matching value with ComboBox2. Once the best match value is choosen, I want to find The best match for the ComboBox3 Value. This value will be contained In one of the sub heading rows under the Choosen Red Font.
I then want textBox one to show the price for the choosen sub heading.