Vlookup Table Dynamic range from other sheet of same workbook

[querylal]

I have two worksheet ThreshXHigh.xlsx and MasterSheet.xlsx in workbook called MasterSheet.xlsm

I want to perform vlookup in MasterSheet.xlsx work sheet in ColumnC. My Source cell is Column B of same MasterSheet.xlsx and Table to look up is in another sheet ThreshXhigh.xlsx cloumn B to U but row value has to be dynamic.

I wrote below code but now have to define "Master" table which gives me table range from ThreshXhigh.xlsx sheet (dynnamic). Can some one please suggest how to define same.

x = 2
While Cells(x, 1).Value <> ""
Cells(x, 3).Value = "=vlookup(B" & x & "& " & Chr(34) & "left(C1,1)" & Chr(34) & ",Master,5,false)"




x = x + 1
Wend

 

[querylal]

I have two worksheet ThreshXHigh.xlsx and MasterSheet.xlsx in workbook called MasterSheet.xlsm

I want to perform vlookup in MasterSheet.xlsx work sheet in ColumnC. My Source cell is Column B of same MasterSheet.xlsx and Table to look up is in another sheet ThreshXhigh.xlsx cloumn B to U but row value has to be dynamic.

I wrote below code but now have to define "Master" table which gives me table range from ThreshXhigh.xlsx sheet (dynnamic). Can some one please suggest how to define same.

x = 2
While Cells(x, 1).Value <> ""
Cells(x, 3).Value = "=vlookup(B" & x & "& " & Chr(34) & "left(C1,1)" & Chr(34) & ",Master,5,false)"

x = x + 1
Wend

Column B (Sector Carrier as Header) Column C (0_CellReselection as Header)
078001_1 vlookup......
078001_1_2
078001_1_1



Cells(x, 3).Value = "=vlookup(B" & x & "& " & Chr(34) & "left(C1,1)" & Chr(34) & ",Master,8,false)"

what should i write to get result highlighted vlookup source cell (concatenation of row of column B value and first digit of Column C) that i get following format..078001_1_0,
078001_1_2_0?