Hi guys, me again.

I have one code like this, its in spanish

=BUSCARV(**L395**;'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;1;FALSO)

I select the word of the cell L395 to vlookup in other book, example I look for the value **1500 **but in the other book say **a1500, **I need put * in the formula like =VLOOKUP("*"&**L395....**

But when I find the value like only **1500 **with the same formula this formula =VLOOKUP("*"&**L395.... **it doesn't work for me cause the formula search the value after other value, cause have "*", how can I make the formula for look the value 1500 for example, before, after or between other value?? I want to have in differents cell a1500, 1500, 1500a, a1500a and find 1500 with VLOOKUP, I have this code for this actually but this slows down my excel because have one "*" like condition for one VLOOKUP

=SI.ERROR(SI(L404=0;"SIN INFO";SI.ERROR(BUSCARV(L404;'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO);SI.ERROR(BUSCARV("*"&L404;'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO);SI.ERROR(BUSCARV(L404&"*";'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO);BUSCARV("*"&L404&"*";'[FACTURAS POR PAGAR (CEMENTO).xlsx]FACTURAS CEMENTO'!D:H;5;FALSO)))));"")