Wilcard for vlookup

  • 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)))));"")


  • Pedro003

    Changed the title of the thread from “Wilcard for searchb” to “Wilcard for vlookup”.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!