krunal123

Board Regular
Joined
Jun 26, 2020
Messages
111
Office Version
  1. 365
Platform
  1. Windows
image_2021-07-12_130925.png
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,079
Office Version
  1. 365
Platform
  1. Windows
It is not clear exactly what you are trying to match, or what "qualifies" as a match.
Remember, while your question is familiar to you, we know nothing about it.
Please explain in detail the logic of how this is supposed to work.
 

krunal123

Board Regular
Joined
Jun 26, 2020
Messages
111
Office Version
  1. 365
Platform
  1. Windows
It is not clear exactly what you are trying to match, or what "qualifies" as a match.
Remember, while your question is familiar to you, we know nothing about it.
Please explain in detail the logic of how this is supposed to work.
I was try particular number find to Invoice Number

EX. EXP/001/20-21

i was match Search "001" In Invoice Number And Match other list D: I Column to match "001"

if than match both list after highlight D:I list & highlight in cell...

This trick use for office data matching , logical Matching.

Pleased, Help me ,

I was try but , i don't know how to update formula & match up both data ?? Pleased Help me.........

image_2021-07-13_085558.png
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,079
Office Version
  1. 365
Platform
  1. Windows
i was match Search "001" In Invoice Number And Match other list D: I Column to match "001"
Unfortunately, your second description is not any less confusing than your first.
It looks like maybe you are trying to match on the number in between the two "/" in the invoice number, but I cannot tell if you are trying to highlight it, or return a "Y" or "N". It is very unclear and confusing.

But here is code that you can use that will pull the number between the two "/" in your invoice number.
For an invoice number in cell A1, this formula will return that value:
Excel Formula:
=TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",100)),100,100))
Maybe that will give you the missing piece you need?
 

Forum statistics

Threads
1,141,715
Messages
5,708,049
Members
421,540
Latest member
quocbinh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top