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...
In general you don't need custom format for the currency. You may apply currency format from ribbon; or Ctrl+1 on cell and select proper one.
Hi again:
I am now in the formulas & functions section. I am trying the VLOOKUP and when I do this it gives me error:
Meat Amount
Beef 100
Chicken 50
Pork 30
Fish 40
Chicken #N/A
can you try it?
I am now in the formulas & functions section. I am trying the VLOOKUP and when I do this it gives me error:
Meat Amount
Beef 100
Chicken 50
Pork 30
Fish 40
Chicken #N/A
can you try it?
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
- Excuse me, do you see any image in my previous answer? I don't see it, but it appears to me that there is an image in my response.
- No, I dont see any image. Sorry
- Hi, can you share some screenshot of the formula you are using please
- =VLOOKUP(A9,A4:B7,2,FALSE)
