Match Function to find last used cell in row

[Buskopan]

Hello

Range A to K contains cliens details (name adres etc)
Range L to BS conains months from 2011 to 2016 where indicated the paymants

Range A1:BX1000 - Dynamic Range Named "LombardAll" contains clients contract numbers
So Combobox1 Rawsorce is "Lombard"
Depending on combobox1 value I want texbox1 to indicate the first unpaid month

Question 1
How the code will look like ?

Question 2 (if 1 question was hard)
How can I get the cell number of vlookup result ?

Something like that results with error.

Private Sub ComboBox1_Change()
me.textbox1.value = "Row N " &  WorksheetFunction.Match(--Me.ComboBox1.Value, Worksheets("Esas").Range("LombardAll"), False)
End Sub

File. (just in case)

 

[Buskopan]

did it finally this way

[COLOR=#000099][FONT=monospace]Private[/FONT][/COLOR][COLOR=#000000][FONT=monospace] [/FONT][/COLOR][COLOR=#000099][FONT=monospace]Sub[/FONT][/COLOR][COLOR=#000000][FONT=monospace] ComboBox1_Change()[/FONT][/COLOR]

[COLOR=#000000][FONT=monospace]st = WorksheetFunction.Match(--Me.ComboBox1.Value, Worksheets([/FONT][/COLOR][COLOR=#666666][FONT=monospace]"Esas"[/FONT][/COLOR][COLOR=#000000][FONT=monospace]).Range([/FONT][/COLOR][COLOR=#666666][FONT=monospace]"newtest"[/FONT][/COLOR][COLOR=#000000][FONT=monospace]), [/FONT][/COLOR][COLOR=#000099][FONT=monospace]False[/FONT][/COLOR][COLOR=#000000][FONT=monospace])[/FONT][/COLOR]
[COLOR=#000000][FONT=monospace]Me.lastPayment.Value = Range([/FONT][/COLOR][COLOR=#666666][FONT=monospace]"B"[/FONT][/COLOR][COLOR=#000000][FONT=monospace] & st).Value[/FONT][/COLOR]

[COLOR=#000000][FONT=monospace]lastcolumn = ActiveSheet.Range([/FONT][/COLOR][COLOR=#666666][FONT=monospace]"AP"[/FONT][/COLOR][COLOR=#000000][FONT=monospace] & st).End(xlToRight).Column[/FONT][/COLOR]
[COLOR=#000000][FONT=monospace]Me.TextBox1.Value = Cells(st, lastcolumn) [/FONT][/COLOR][COLOR=#006600][FONT=monospace]'[/FONT][/COLOR]
[COLOR=#000000][FONT=monospace]Me.TextBox2.Value = Cells([/FONT][/COLOR][COLOR=#CC0000][FONT=monospace]1[/FONT][/COLOR][COLOR=#000000][FONT=monospace], lastcolumn)[/FONT][/COLOR]

[COLOR=#000099][FONT=monospace]End[/FONT][/COLOR][COLOR=#000000][FONT=monospace] [/FONT][/COLOR][COLOR=#000099][FONT=monospace]Sub[/FONT][/COLOR]