Combine INDEX MATCH and MID functions
nastya9307
Posted messages
16
Status
Member
-
nastya9307 Posted messages 16 Status Member -
nastya9307 Posted messages 16 Status Member -
Hello
I have a list of data with 8 symbols (1809-CAR).
I created a database for the last 4 symbols and the definition of what it is (-CAR - Carrefour).
I want to give a definition to each of the terms from the entire list (search for a part of a number in my database and display its definition from the second column).
I tried to create a formula, but it doesn't work.
Here it is:
=INDEX("database";MATCH(MID(1809-CAR;5;4);database;0);2)
Could you please help me?
I have a list of data with 8 symbols (1809-CAR).
I created a database for the last 4 symbols and the definition of what it is (-CAR - Carrefour).
I want to give a definition to each of the terms from the entire list (search for a part of a number in my database and display its definition from the second column).
I tried to create a formula, but it doesn't work.
Here it is:
=INDEX("database";MATCH(MID(1809-CAR;5;4);database;0);2)
Could you please help me?
1 answer
-
Hello,
Index Equiv is used for left VLOOKUPs
Your formula can simply be summarized as follows:
=Sierreur(VLOOKUP(Right(1809-CAR,4),"basededonnees",2,FALSE),"Not Found")
If "basededonnees" is the name given to range A:B, and your acronym is located in column A.
--
To conquer without peril is to triumph without glory.
Pierre Corneille, Le Cid
