Forum Discussion
help: create a custom number format
I am trying to create one, but when I do this: If I want to add dollars or euros it does not let me, perhaps I am going something wrong¿? Select Custom. In the Type list, select an existing...
Natalia_Farr I am typing to you from Peru and my Excel is configured in Spanish, instead of BUSCARV it would be VLOOKUP.
I don't see error in the formula you comment. It may be that the word you are looking for is not as it is in the search matrix, make sure there are no other spaces in your word you are looking for and in your matrix
The #N/A Error appears when the formula does not find what you was asked for. In VLOOKUP it would be that it doesn't find it in the lookup array
- OK I have tried again and all good now
