Set Value Of ComboBox Based On Chosen Item From Another

I have two comboboxs on a userform, both are populated like this:
(ComboBox1 is a different sheet/column)



' Sets Remarks in ComboBox4 Contents
With Worksheets("Data")
Set rng = . Range(.Cells(1, "C"), .Cells(Rows.Count, "C").End(xlUp))
End With
With ComboBox4
.RowSource = rng.Address(external:=True)
End With
The function is that ComboBox1 will populate the names on lets say Sheet1, Column A, and when selected will populate by offset all the other Textboxs, and ComboBoxs.

Textbox1 is a date
ComboBox4 is populated off of items from the data sheet
ComboBox1 is populated off of sheet1 and provides names, then fills the userform fields

In populating the Userform, it fills Combobox4.value by the offset value of the selected name.

That cell does not contain the same info that was loaded into the ComboBox initally, and it does not show it. All other ComboBox entries match preloaded values, and show.

How do I get the ComboBox to display what is in the OffSet cell value, rather than blank because its different?

• Fill ComboBox Based On Item Chosen In Another
• Color ComboBox Based On Item Chosen
• Find Chosen ComboBox Item
• Determine If ComboBox Item Chosen
• Check If ComboBox Has Item Chosen
• Go To Cell Housing Chosen ComboBox Item
• Remove Chosen ComboBox Item Plus X Rows
• Go To Cell Based On List Item Chosen From Drop-Down
• Calculate Average Based On Item Chosen From List
• Set ComboBox Value Based On Text If In The ComboBox List
• Return Corresponding Value For Chosen Item
• Breakdown Details Of Chosen PivotTable Item
• Select Item In Range Chosen From ListBox
• Lookup Details Relevant To Chosen Item
• Pass Chosen ListBox Item Number To Cell
• Copy Chosen Combobox Value
• Go To Range Chosen: ComboBox
• Return Corresponding Data Chosen From ComboBox
• Return Chosen Value From ComboBox Control
• Get Chosen Value From User Form ComboBox
• Column Number Of Chosen ComboBox Value
• Combobox Validation: Only Listed Items Can Be Chosen/Used
• Hide/Show Sheets Chosen In ComboBox
• Join Chosen ComboBox Text With All Used Cells In Range
• Remove An Item From Combobox
• Remove Item From ComboBox
• Control Toolbox ComboBox To Return Chosen List Number
• Add Item To Combobox On Sheet
• Get/Determine Selected Item In ComboBox
• Fill ComboBox With Only 1 Occurence Of Each Item
• Selected Item In Combobox, Updates Textboxes
• Pass ComboBox Value X Rows Down From Chosem Item
• Delete Currently Displayed Combobox Item With Commandbutton Click
• Assigning A Category To An Item Number Based On The First Two Characters Of The Item Number
• Set Combo Box Controls To 1st Item
• Running A Specific Maro Through The Combobox Feature When A Specific Word Is Chosen
• Filling Combobox Based On Another Combobox.text Value.
• Populate Combobox Based On Selection Of Other Combobox
• How To Set ComboBox Default Value
• Set Focus On Combobox
• Set ComboBox RowSource To Dynamic Range
• ComboBox Output Set In Date Format
• Fill List Based On Chosen Value In Another
• Dynamically Set Combobox List Fill Range
• Sum If Function Based On Months Chosen
• Select A List Based On The Color Chosen
• Repopulate ListBox Based On Range Chosen
• Create List Based On Word Chosen
• Pivot Chart Error: Unable To Set The _Default Property Of The Pivot Item Class
• Populate Cells Based On Chosen Drop Down List Value