Bom dia!
Tenho uma planilha onde uma coluna A "Nota Fiscal" contem as NF A, B, C, D, E. e na coluna B e C tem o Valor "MINIMO" e "MAXIMO" EX: NF A de 1 a 10, NF B de 11 a 20, NF C de 21 a 30.... e tenho uma coluna com números aleatórios 7, 9, 20, 31, 41, 16, 24, 19.
Gostaria de saber uma formula que me mostre qual a Nota Fiscal desses números aleatórios uma vez que pra localizar eles terei que saber se ele estão entre o valor MINIMO E MAXIMO.
EXCEL.JPG
This by no means is the final answer, it will just show others what your question is.
In G2 enter this, and drag down
Formula:
Please Login or Register to view this content.
May be
Formula:Please Login or Register to view this content.
Or in pt
Formula:Please Login or Register to view this content.
See the file
Maybe:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Los siento ....mi espanol is mal! If you can put "Nota Fiscal" in Column D it would make things easier. Then you could use the Vlookup formula. in G2 put the formula. This formula is NOT looking for an exact match and it worked for me. Otherwise, you may need to use an Index Match formula?
Please Login or Register to view this content.
Bueno suerte.
As well as requiring the data to be restructured, VLOOKUP as described, does not cater for numbers below or above the minimum/maximum values in the table.
Deu Certo, Obrigado
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
A solução deu certo parcial pois se eu colocar um numero maior que 50 ele irá trazer a Nota fiscal E, sendo que não tem nenhuma nota atrelada pra esse número. teria uma forma de impedir de fazer isso?
See post #4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks