Look For num 3

If I'm looking for "68" I know that "686.6" is a match but what about these:
"568"?
"861"?
"586"?

BTW, if possible you should always supply an existing workbook that has similar functions

Martin

in this situation  the number have to be exact number
for example  number in column f is 486

then query is for 3 num   = 486
then for 2 num query = 48

to my understand this is the most
similar funtion workbook

but is only 2 num query
n2-AL_similarexample.xlsm

If that's true then with the data in the workbook you attached there are no numbers in column "F" that are less than 100 so there will never be a "Find 2" match.

Martin
I did not understand the comments you made
ID: 42226664

Please answer "True" or "False". If you are looking for "48" then "486" is a match, but "148" isn't.

Martin

then for 2 num query = 48

in this case don't have to be the exact number
but what i mean is get the frist 2 digit ( the exact to digit)
because i look for jus the first 2

Please answer "True" or "False". If you are looking for "48" then "486" is a match, but "148" isn't.

false

Martin
because in this situation

the oder is important
eaxmple  486    =  4 8    ( this order is important )= 48X   (  X can be any )

Now I'm confused. Please tell me which of these are a match if I'm looking for "48".

486
648
846

OK I understand now.

Now I'm confused. Please tell me which of these are a match if I'm looking for "48".

486  ====   YES = MATCH
648 - NO
846  -NO

MARtin
 almost pefect  just some minors adjustments to move foward

find 3 and find 2 working
(but the quantity found is the detail)

like add the column G so i can see the reference ( in yellow better )

find 3 and find 2 working
(but the quantity found is the detail)

Excel shows 11 because the 11th one is "547" and according to what you've said, that's not a match.

Martin you Rigth !!
keep that way !

The picture in post ID: 42226692 shows column "G". That used to be included until you said you only wanted L, M and N. If you want column "G", go back to one of your older workbooks. Everything should work the way you want it to.

Martin  I agreed with you on that workbook
but what i try in here is show that i will need coulum G like that pic in this NUM sheet
so i can see the reference in this workbook

OK, but in this case you want "F" and not "G", correct?

If we did this would you still need column "F"?

Martin you rigth  is column F not G in NUM sheet

Martin
If we did this would you still need column "F"?

that ok  and looks great

left out column F then

Grea JOb ! Great Expert !

Martin I open new question
for need query column G location 7
and show 13 set  coulmns L , M , N

Here is the heading change.
29045909a.xlsm

Great JOb !! that let me see the source thanks !!