• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Look up Unique item Value if Criteria

K

kme

Member
1. Only Formula Required Colum From E18 and F18 (Pick Data From Data Sheet Account Credit Days and Amount Against Customer.
2. Data A group Company Customer Data . Same Customer Different Branches Make Bills. So Same Customer Days and Amount Limit Just Came Any Branch Code . But "PBBB" Came Then Days and Amount Limit Should Come Even If Same Customer
3. VLOOKUP Formula Not Suite A large Data Sett
 

Attachments

  • Data.xlsx
    15.1 KB · Views: 2
Can't answer that. then? ;)

In E18 copied down:

=IFERROR(FILTER(Data!$I$4:$J$10001,(Data!$A$3:$A$10000=C18)*(Data!$G$4:$G$10001=B18)),"")
 

Dear AliGW Sir . Really Appreciate .​

​

In This Data Work Sheet Customer Name Need to Pick From Data Sheet "Colum-C "Particulars" . Previse Formula Customer Name Picked From Column Data!$A$3:$A$10000 . Due to "Column A " Customer Name And "Column c " Customer name are Differentiate . ​

​

FIVE STAR PHONES&COMUPTER AND ELECTRONIC-140706-10 2024-11​

FIVE STAR PHONES&COMUPTER AND ELECTRONIC-14(C)​

​

Colum A customer Name Along With System Code Came .​

​

Can Create Customer Name Pick From "Colum-C "Particulars" Instead of Data!$A$3:$A$10000​

 

Attachments

  • Data.xlsx
    15.1 KB · Views: 6
Last edited:
Any chance you could explain your requirement in plain English? What happened when you tried to adapt the formula I gave you? Please don't drip feed your requirements.
 
By the way, I am not a Sir - do I really look like a man???

Try this:

=IFERROR(FILTER(Data!$I$4:$J$10001,(LEFT(Data!$A$3:$A$10000,20)=LEFT(C18,20))*(Data!$G$4:$G$10001=B18)),"")
 
You must log in or register to reply here.
Back
Top