The invoice number from the list

[Geo Jul]

Dear all​

Please need your help​

Invoice number between range​ Serial no.​ Invoice no.​ Month​ Sales Figures​ Sale Range​ Amounts between Sales range Invoice no. 1 190 BXJ​ 7-Oct-23​ $ 3,827.00​ 1-999​ 756,936,769,742​ 392 YGX,204 RRP,446 QRC,123 RBJ​ the result should read like this​ 2 126 ZHK​ 5-Jul-23​ $ 4,207.00​ 1000-1999​ 1341,1802,1798,1452​ 3 143 SPV​ 16-Oct-23​ $ 6,069.00​ 2000-2999​ 2131,2710​ 4 328 PMC​ 19-May-23​ $ 14,112.00​ 3000-3999​ 3827,3973,3257,3364​ 5 124 XNS​ 7-Jun-23​ $ 1,341.00​ 4000-4999​ 4207,4025,4821,4899,4861,4019,4955,4562​ 6 392 YGX​ 24-Apr-23​ $ 756.00​ 5000-5999​ 5097,5044,5543,5474,5243​ 7 280 HFS​ 31-Oct-23​ $ 11,914.00​ 6000-6999​ 6069,6363,6229​ 8 386 HWK​ 13-Feb-23​ $ 13,028.00​ 7000-7999​ 7642​ 9 333 MZG​ 19-Feb-23​ $ 12,946.00​ 8000-8999​ 8253,8188,8169​ 10 345 ZVW​ 12-Mar-23​ $ 14,295.00​ 9000-9999​ 9804​ 11 370 NRC​ 9-Nov-23​ $ 13,267.00​ 10000-15000​ 14112,11914,13028,12946,14295,13267,14191,13624,12335,10286,13733,10425,13962,11964,12054​ 12 204 RRP​ 17-Apr-23​ $ 936.00​ 13 408 KBF​ 2-Jul-23​ $ 14,191.00​ 14 361 OYY​ 12-Dec-23​ $ 5,097.00​ 15 173 INA​ 27-Aug-23​ $ 8,253.00​ 16 133 VFC​ 5-Aug-23​ $ 8,188.00​ Formula used in G 3​ 17 233 XBD​ 9-Jul-23​ $ 2,131.00​ 18 240 GLO​ 25-May-23​ $ 8,169.00​ =TEXTJOIN(",",,IFERROR(LOOKUP(($D$3:$D$52>=LEFT(F3,1)+0)*($D$3:$D$52<=RIGHT(F3,LEN(F3)-FIND("-",F3))+0)*ROW($D$3:$D$52),ROW($D$3:$D$52),$D$3:$D$52),""))​ 19 433 OQI​ 8-Nov-23​ $ 1,802.00​ 20 355 CPF​ 26-Apr-23​ $ 13,624.00​ 21 271 OXZ​ 15-May-23​ $ 3,973.00​ 22 313 YGJ​ 14-Jun-23​ $ 2,710.00​ 23 288 HSK​ 26-Oct-23​ $ 12,335.00​ 24 387 EUE​ 16-Dec-23​ $ 5,044.00​ 25 446 QRC​ 25-Jun-23​ $ 769.00​ 26 143 LOR​ 27-Nov-23​ $ 10,286.00​ 27 446 AUC​ 5-Feb-23​ $ 6,363.00​ 28 314 EAV​ 6-Mar-23​ $ 4,025.00​ 29 273 NQX​ 15-Jul-23​ $ 5,543.00​ 30 239 FFR​ 13-Oct-23​ $ 4,821.00​ 31 338 YVD​ 7-Jun-23​ $ 1,798.00​ 32 149 XJC​ 15-Dec-23​ $ 9,804.00​ 33 316 VFL​ 28-Jan-23​ $ 4,899.00​ 34 260 GDS​ 22-Feb-23​ $ 13,733.00​ 35 280 BYW​ 22-Jul-23​ $ 10,425.00​ 36 451 WXX​ 27-Aug-23​ $ 3,257.00​ 37 421 TXB​ 6-May-23​ $ 13,962.00​ 38 384 MPP​ 10-Nov-23​ $ 5,474.00​ 39 431 EKK​ 13-Jun-23​ $ 11,964.00​ 40 377 UKT​ 18-Jan-23​ $ 4,861.00​ 41 228 MCD​ 25-Feb-23​ $ 4,019.00​ 42 259 TFS​ 15-Oct-23​ $ 5,243.00​ 43 184 WMM​ 17-Sep-23​ $ 12,054.00​ 44 123 RBJ​ 17-Sep-23​ $ 742.00​ 45 428 YPF​ 11-Sep-23​ $ 1,452.00​ 46 255 YUI​ 18-Sep-23​ $ 4,955.00​ 47 353 LNM​ 9-Jul-23​ $ 6,229.00​ 48 148 NLD​ 13-Nov-23​ $ 4,562.00​ 49 159 SNV​ 13-Mar-23​ $ 7,642.00​ 50 126 GPI​ 26-Dec-23​ $ 3,364.00​ Total Sales​ 344461.00​

 

[alansidman]

What's your date range criteria?

 

[Geo Jul]

What's your date range criteria?

the formula in g3 column gave me all the amounts in a list between 1-999 (756$, 936$, 769$, 742$)​

I need the invoice number for these amounts​

Dates are 01/01/2023 till 31/12/2023 (Thanks in Advise)​

 

[Geo Jul]

Dear all​

Please need your help​

Invoice number between range​ Serial no.​ Invoice no.​ Month​ Sales Figures​ Sale Range​ Amounts between Sales range Invoice no. 1 190 BXJ​ 7-Oct-23​ $ 3,827.00​ 1-999​ 756,936,769,742​ 392 YGX,204 RRP,446 QRC,123 RBJ​ the result should read like this​ 2 126 ZHK​ 5-Jul-23​ $ 4,207.00​ 1000-1999​ 1341,1802,1798,1452​ 3 143 SPV​ 16-Oct-23​ $ 6,069.00​ 2000-2999​ 2131,2710​ 4 328 PMC​ 19-May-23​ $ 14,112.00​ 3000-3999​ 3827,3973,3257,3364​ 5 124 XNS​ 7-Jun-23​ $ 1,341.00​ 4000-4999​ 4207,4025,4821,4899,4861,4019,4955,4562​ 6 392 YGX​ 24-Apr-23​ $ 756.00​ 5000-5999​ 5097,5044,5543,5474,5243​ 7 280 HFS​ 31-Oct-23​ $ 11,914.00​ 6000-6999​ 6069,6363,6229​ 8 386 HWK​ 13-Feb-23​ $ 13,028.00​ 7000-7999​ 7642​ 9 333 MZG​ 19-Feb-23​ $ 12,946.00​ 8000-8999​ 8253,8188,8169​ 10 345 ZVW​ 12-Mar-23​ $ 14,295.00​ 9000-9999​ 9804​ 11 370 NRC​ 9-Nov-23​ $ 13,267.00​ 10000-15000​ 14112,11914,13028,12946,14295,13267,14191,13624,12335,10286,13733,10425,13962,11964,12054​ 12 204 RRP​ 17-Apr-23​ $ 936.00​ 13 408 KBF​ 2-Jul-23​ $ 14,191.00​ 14 361 OYY​ 12-Dec-23​ $ 5,097.00​ 15 173 INA​ 27-Aug-23​ $ 8,253.00​ 16 133 VFC​ 5-Aug-23​ $ 8,188.00​ Formula used in G 3​ 17 233 XBD​ 9-Jul-23​ $ 2,131.00​ 18 240 GLO​ 25-May-23​ $ 8,169.00​ =TEXTJOIN(",",,IFERROR(LOOKUP(($D$3:$D$52>=LEFT(F3,1)+0)*($D$3:$D$52<=RIGHT(F3,LEN(F3)-FIND("-",F3))+0)*ROW($D$3:$D$52),ROW($D$3:$D$52),$D$3:$D$52),""))​ 19 433 OQI​ 8-Nov-23​ $ 1,802.00​ 20 355 CPF​ 26-Apr-23​ $ 13,624.00​ 21 271 OXZ​ 15-May-23​ $ 3,973.00​ 22 313 YGJ​ 14-Jun-23​ $ 2,710.00​ 23 288 HSK​ 26-Oct-23​ $ 12,335.00​ 24 387 EUE​ 16-Dec-23​ $ 5,044.00​ 25 446 QRC​ 25-Jun-23​ $ 769.00​ 26 143 LOR​ 27-Nov-23​ $ 10,286.00​ 27 446 AUC​ 5-Feb-23​ $ 6,363.00​ 28 314 EAV​ 6-Mar-23​ $ 4,025.00​ 29 273 NQX​ 15-Jul-23​ $ 5,543.00​ 30 239 FFR​ 13-Oct-23​ $ 4,821.00​ 31 338 YVD​ 7-Jun-23​ $ 1,798.00​ 32 149 XJC​ 15-Dec-23​ $ 9,804.00​ 33 316 VFL​ 28-Jan-23​ $ 4,899.00​ 34 260 GDS​ 22-Feb-23​ $ 13,733.00​ 35 280 BYW​ 22-Jul-23​ $ 10,425.00​ 36 451 WXX​ 27-Aug-23​ $ 3,257.00​ 37 421 TXB​ 6-May-23​ $ 13,962.00​ 38 384 MPP​ 10-Nov-23​ $ 5,474.00​ 39 431 EKK​ 13-Jun-23​ $ 11,964.00​ 40 377 UKT​ 18-Jan-23​ $ 4,861.00​ 41 228 MCD​ 25-Feb-23​ $ 4,019.00​ 42 259 TFS​ 15-Oct-23​ $ 5,243.00​ 43 184 WMM​ 17-Sep-23​ $ 12,054.00​ 44 123 RBJ​ 17-Sep-23​ $ 742.00​ 45 428 YPF​ 11-Sep-23​ $ 1,452.00​ 46 255 YUI​ 18-Sep-23​ $ 4,955.00​ 47 353 LNM​ 9-Jul-23​ $ 6,229.00​ 48 148 NLD​ 13-Nov-23​ $ 4,562.00​ 49 159 SNV​ 13-Mar-23​ $ 7,642.00​ 50 126 GPI​ 26-Dec-23​ $ 3,364.00​ Total Sales​ 344461.00​

What's your date range criteria?

Thank you I Solved my question

 

[Geo Jul]

Dear all​

Please need your help​

Invoice number between range​ Serial no.​ Invoice no.​ Month​ Sales Figures​ Sale Range​ Amounts between Sales range Invoice no. 1 190 BXJ​ 7-Oct-23​ $ 3,827.00​ 1-999​ 756,936,769,742​ 392 YGX,204 RRP,446 QRC,123 RBJ​ the result should read like this​ 2 126 ZHK​ 5-Jul-23​ $ 4,207.00​ 1000-1999​ 1341,1802,1798,1452​ 3 143 SPV​ 16-Oct-23​ $ 6,069.00​ 2000-2999​ 2131,2710​ 4 328 PMC​ 19-May-23​ $ 14,112.00​ 3000-3999​ 3827,3973,3257,3364​ 5 124 XNS​ 7-Jun-23​ $ 1,341.00​ 4000-4999​ 4207,4025,4821,4899,4861,4019,4955,4562​ 6 392 YGX​ 24-Apr-23​ $ 756.00​ 5000-5999​ 5097,5044,5543,5474,5243​ 7 280 HFS​ 31-Oct-23​ $ 11,914.00​ 6000-6999​ 6069,6363,6229​ 8 386 HWK​ 13-Feb-23​ $ 13,028.00​ 7000-7999​ 7642​ 9 333 MZG​ 19-Feb-23​ $ 12,946.00​ 8000-8999​ 8253,8188,8169​ 10 345 ZVW​ 12-Mar-23​ $ 14,295.00​ 9000-9999​ 9804​ 11 370 NRC​ 9-Nov-23​ $ 13,267.00​ 10000-15000​ 14112,11914,13028,12946,14295,13267,14191,13624,12335,10286,13733,10425,13962,11964,12054​ 12 204 RRP​ 17-Apr-23​ $ 936.00​ 13 408 KBF​ 2-Jul-23​ $ 14,191.00​ 14 361 OYY​ 12-Dec-23​ $ 5,097.00​ 15 173 INA​ 27-Aug-23​ $ 8,253.00​ 16 133 VFC​ 5-Aug-23​ $ 8,188.00​ Formula used in G 3​ 17 233 XBD​ 9-Jul-23​ $ 2,131.00​ 18 240 GLO​ 25-May-23​ $ 8,169.00​ =TEXTJOIN(",",,IFERROR(LOOKUP(($D$3:$D$52>=LEFT(F3,1)+0)*($D$3:$D$52<=RIGHT(F3,LEN(F3)-FIND("-",F3))+0)*ROW($D$3:$D$52),ROW($D$3:$D$52),$D$3:$D$52),""))​ 19 433 OQI​ 8-Nov-23​ $ 1,802.00​ 20 355 CPF​ 26-Apr-23​ $ 13,624.00​ 21 271 OXZ​ 15-May-23​ $ 3,973.00​ 22 313 YGJ​ 14-Jun-23​ $ 2,710.00​ 23 288 HSK​ 26-Oct-23​ $ 12,335.00​ 24 387 EUE​ 16-Dec-23​ $ 5,044.00​ 25 446 QRC​ 25-Jun-23​ $ 769.00​ 26 143 LOR​ 27-Nov-23​ $ 10,286.00​ 27 446 AUC​ 5-Feb-23​ $ 6,363.00​ 28 314 EAV​ 6-Mar-23​ $ 4,025.00​ 29 273 NQX​ 15-Jul-23​ $ 5,543.00​ 30 239 FFR​ 13-Oct-23​ $ 4,821.00​ 31 338 YVD​ 7-Jun-23​ $ 1,798.00​ 32 149 XJC​ 15-Dec-23​ $ 9,804.00​ 33 316 VFL​ 28-Jan-23​ $ 4,899.00​ 34 260 GDS​ 22-Feb-23​ $ 13,733.00​ 35 280 BYW​ 22-Jul-23​ $ 10,425.00​ 36 451 WXX​ 27-Aug-23​ $ 3,257.00​ 37 421 TXB​ 6-May-23​ $ 13,962.00​ 38 384 MPP​ 10-Nov-23​ $ 5,474.00​ 39 431 EKK​ 13-Jun-23​ $ 11,964.00​ 40 377 UKT​ 18-Jan-23​ $ 4,861.00​ 41 228 MCD​ 25-Feb-23​ $ 4,019.00​ 42 259 TFS​ 15-Oct-23​ $ 5,243.00​ 43 184 WMM​ 17-Sep-23​ $ 12,054.00​ 44 123 RBJ​ 17-Sep-23​ $ 742.00​ 45 428 YPF​ 11-Sep-23​ $ 1,452.00​ 46 255 YUI​ 18-Sep-23​ $ 4,955.00​ 47 353 LNM​ 9-Jul-23​ $ 6,229.00​ 48 148 NLD​ 13-Nov-23​ $ 4,562.00​ 49 159 SNV​ 13-Mar-23​ $ 7,642.00​ 50 126 GPI​ 26-Dec-23​ $ 3,364.00​ Total Sales​ 344461.00​

Thank you I Solved my question

 

[Peter_SSs]

Thank you I Solved my question

Glad you have found a solution. Thanks for letting us know.
It would be interesting to see what solution that you used if you would care to share it.