Reverse Vlookup

[Jadre]

could there to reverse vlookup like instead of getting a number out of the list it will take the number in the list

the number that i want in the list is in J3 and the list in B4:D23 could there be a way to take the number in J3 and scroll down the list looking for a certain name then when find it, it will go 3 cells sidways and place the number from J3 there

using a formula or macro


Thanks

 

[C Moore]

You have to have the person's name to look for. If you put the name to look for in K3 you can use the following:

Sub add_number()
    Number = Range("J3") 'cell to look for number
    person = Range("K3") 'cell to look for name
    Range("B3").CurrentRegion.Find(what:=person, after:=[b3], SearchOrder:=xlByRows, SearchDirection:=xlNext).Offset(0, 3).Value = Number
End Sub

 

[Jadre]

i hooked up the macro moved the name to K3 but it doesn't do anything, did i do something wrong???

 

[C Moore]

Step through it using F8 in the visual basic window. Yellow highlight means this is what it will do next. At each step, make sure its doing something, for the first two lines hover over 'number' or 'person' with your mouse and it should show a value.

 

[Jadre]

I tried it, it said number=empty and name=Sheet2 ?????????????