ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Searching in a row with push on a button (https://www.excelbanter.com/excel-programming/288692-searching-row-push-button.html)

Christian R.

Searching in a row with push on a button
 
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






All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com