Hi,

I am having difficulty with the following and any help is greatly appreciated;

I am trying to fill a cell value based on a value in the column to it's left, and using a value from a separate sheet.

For example: Column B is Client Name, Column C is Client Number. I have a separate worksheet titled "Client No List." I want to be able to enter the client name (for example in row 5 - so B5), and have the client number automatically fill C5 with the number.

I had this working before, but someone messed with sheet and I can't figure it out again!

Here is what I had:

If Not Intersect(Target, Columns("B")) Is Nothing Then
Dim tmp As Range
Set tmp = Sheets("Client No List").Range("A2:A1500").Find(Target.Value)
If Not tmp Is Nothing Then
Target.Offset(0, 1).Value = tmp.Offset(0, 1).Value
Else
Target.Offset(0, 1).Value = "???"
End If
End If