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?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
- Hi, can you share some screenshot of the formula you are using please
- =VLOOKUP(A9,A4:B7,2,FALSE)
ok thank you Sergei. I am doing this training https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb,
if I need any more help I will tell you.
- Hi Natalia, could you re-send the link please? I get an error when I try to open it
- try it now: https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
