VBA Lookup from List and output Userform textbox in adjacent cell

Hi I have looked on the forum for this, but can't seem to find what I want.

This is a basic formula or what needs to happen.

If x is in y then
show q in v

X - Is a postcode in a dataset on a tab
Y - is on a seperate tab and is a list of all relevant postcodes.
Q - is the txtbox field on a userform
V - is the adjacenet cell to X (offset,1)

Ideally I would like for it to loop through each cell on the list which has different rows each month.

I'm using the below, but its a bit clumsey.

Please Login or Register  to view this content.

Think I might have done it.

Please Login or Register  to view this content.

Actually the Lookup Cell is a Concate of 2 cells. Can someone please advise why the below is not working. The Cell is offset by 4 and needs to be added to the current cell that is being looked up.
Its the part in Bold that is not working.

Please Login or Register  to view this content.

"Dim sal" ???

What do you mean?

I don't see in your code where you have Dimensioned the variable "sal".

Dim sal AS ???

This is as far as I can get cuz I don't have the rest of your project. The text is RED are the changes I made to correct error messages here.

I may have missed one or two ...

Please Login or Register  to view this content.

The code works fine, the issue is the following line of code

Please Login or Register  to view this content.

What I want to happen here is to concatenate the current cell with a cell offset by 1 and this value appear in FindZone.

Perfect. Thank you xlnitwit as the Irish would say that works like a charm. Thank you for simplifying my code as well. Really appreciated.