I have a sheet with several rows, product numbers in columns A and matching barcodes in B. Using a userform, I would like to input the barcode into a textbox, perform a search and return the product number that has been found into a textbox. I am not sure if i need to use vlookup, match and then offset. Thank's in advance.
Last edited by San75; 04-04-2019 at 06:38 AM.
Take a look at INDEX.
Index has the format INDEX (Range, Row Number, Column Number) - in your case row number can be found with MATCH and column number is 1.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks