# localizar valor entre intervalo de 2 valores

1. ## localizar valor entre intervalo de 2 valores

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

2. ## Re: localizar valor entre intervalo de 2 valores

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.`

3. ## Re: localizar valor entre intervalo de 2 valores

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

4. ## Re: localizar valor entre intervalo de 2 valores

Maybe:
Formula:
`Please Login or Register  to view this content.`

5. ## Re: localizar valor entre intervalo de 2 valores

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
``Please Login or Register  to view this content.``
. This formula is NOT looking for an exact match and it worked for me. Otherwise, you may need to use an Index Match formula?
Bueno suerte.

6. ## Re: localizar valor entre intervalo de 2 valores

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.

8. ## Re: localizar valor entre intervalo de 2 valores

You're welcome.

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
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.

9. ## Re: localizar valor entre intervalo de 2 valores

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?

10. ## Re: localizar valor entre intervalo de 2 valores

See post #4

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1