Invoice No extract based on Rate of tax

[m9vukyem]

Dear Sir
Please Provide the Excel formula to get the Invoice No as per My Required rate of tax wise

 

[AlanSidman]

Join your two tables in Power Query and sort ascending.

 

[m9vukyem]

Join your two tables in Power Query and sort ascending.

Thank you sir, but I need a formula

 

[vletm]

m9vukyem​

How did You get those Your red values?
My sample: Check cell F3.

 

[m9vukyem]

I entered Manually,at present the rate of tax under GST ACT only 0,5,12,18,28 i want to extract those invoice list separately

 

[m9vukyem]

I need Invoice Numbers separately available in data sheet "c" Column Based on above rate of tax

 

[vletm]

Could You show - what do You would like to get?

 

[m9vukyem]

I used Filter button in data sheet and filtered above rate of tax only and paste the invoice numbers in Inv No extract Sheet of Col A

 

[vletm]

2nd sample of show