INDEX, MATCH function in VBA Solved

Question

Hello I would like to convert the INDEX,MATCH function into VBA if possible I have my workbook attached, I want to find this formula in VBA knowing that I have 2 sheets, the first one is the source and the second one, where I want to put the code to get the result thank you  https://www.cjoint.com/c/IJxqBw305fn

via55 · Answer

Hello  1) It is not INDEX MATCH that should be used here since there is only one piece of data, the code, and not two  2) In VBA for the name it will be: result= Application.WorksheetFunction.VLookup(code to search for,search range,2,0) For the amount it's the same, just replace the 2 with 3  Best regards Via -- "Imagination is more important than knowledge."    A. Einstein

via55 · Answer

Re  1) Part of my first reply got lost! I was saying that you shouldn't use INDEX MATCH but VLOOKUP  And why do you want to do it with a macro when the formula is enough in the table?  2) If you insist on doing it with a VBA macro, I'm willing to adapt it to your file, but I need to know exactly what you want: - a specialized function that will replace the formula in the table cells to display the result? - or a macro that fills the entire table? But in that case, what will be the trigger event for the macro? A keyboard shortcut or a button on the sheet?

via55 · Answer

In this case, here it is: macro triggered when entering column B, no need for a keyboard shortcut ☺ https://mon-partage.fr/f/KbVBRdRE/

via55 · Answer

Good We're moving to resolved ☺  -- "Imagination is more important than knowledge." A. Einstein

INDEX, MATCH function in VBA

4 answers

Adobe reader pdf

Copy/paste scanned text jpeg format

Windows 10 updates that won’t install

Texture issues in enshrouded

Startup error message

Black screen on hp pc

Case fan not working

Username and password

How to delete quarantine files in defender?

Taskbar icon visibility