Hello,

i want to integrate a button in my sheet. When I push it, it should
look in field 021, There is a number in this field. After this, the
programm should look in a matrix like a SVERWEIS. (I don't know
the english word for it. It's the function that looks in a column for
my number an takes the X-field on the right. Like thist =SVERWEIS(5;H2:K4;3))

How can I programm this SVERWEIS in VBA ?
And I need about 6 numbers on the right side of my searching number.
Must I make 6 SVERWEIS ?

I hope my problem ist understandable.

Thanks
Bye