• 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.

lookup data if unique column not to be made..

R

Ramesh Deo

Member
Hi SM & NK sir,

Please see the attached sample file in which need to fetch data in BankName column from Source-sheet(BankName), I tried it but in this data set unique column can't to be made ,then how can we fetch exact data.Please resolve this.
 

Attachments

Hi Ramesh,

Try below array formula in H2 and copy down. Note there are lot of trailing spaces in you data. If they would not have been there the formula would have been a bit shorter.

Code: 
=IF(OR(G2="Cheque",G2="Draft",G2="Online"),INDEX('BankName sheet'!$F$2:$F$987,MATCH(TRIM(Outputsheet!B2)&TRIM(Outputsheet!C2)&TRIM(Outputsheet!D2)&TRIM(Outputsheet!J2)&TRIM(F2),TRIM('BankName sheet'!$A$2:$A$987)&TRIM('BankName sheet'!$B$2:$B$987)&TRIM('BankName sheet'!$C$2:$C$987)&TRIM('BankName sheet'!$D$2:$D$987)&TRIM('BankName sheet'!$E$2:$E$987),0)),"NA")

Regards,
 
You must log in or register to reply here.
Back
Top