Forum Discussion
La función BUSCARV no encuentra el valor que resulta de una fórmula.
Functions like VLOOKUP and MATCH won't find a match if the lookup value is text and the lookup column contains numbers (or vice versa). In other words, "123" does not match 123. This is often a problem with dates, which should be stored as numbers (formatted like dates) rather than as text.
You can coerce text into numbers by prefixing it with two minus signs: --"123"
You can convert text into numbers by copying a blank cell, then selecting the cells to be converted and using the Home... Paste... Paste Special... Add ribbon item.
Functions like VLOOKUP and MATCH won't find a match if the lookup value is text and the lookup column contains numbers (or vice versa). In other words, "123" does not match 123. This is often a problem with dates, which should be stored as numbers (formatted like dates) rather than as text.
You can coerce text into numbers by prefixing it with two minus signs: --"123"
You can convert text into numbers by copying a blank cell, then selecting the cells to be converted and using the Home... Paste... Paste Special... Add ribbon item.
Gracias por su respuesta byundt1635. Con ella he podido darme cuenta que del verdadero error pues no era lo que inicialmente pensaba sino que la fórmula no fue correctamente alimentada debido a que excluía una parte del rango de las celdas en las que debía buscar; lo que llevaba a marcar error cuando se le pedía encontrar un número que estaba fuera del rango incorrectamente señalado.
