![]() |
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