In Sheet "Asset". Looking to match Column B and Column A in Sheet "Asset Info" then display Column D in "Asset Info".
However have a few criteria if it doesn't match.
1) Look for anything "CN02" display "LEDGER"
2) Look anything in the cell that match. ie B4 and B10 in "Asset"
3) If nothing match in Asset Info, would like to say "NO MATCH"
4) If detect blank cell, display " MISSING BARCODE"
I hope that make sense. Thank you for your help.
-Gim
Please try at C2
=IF(B2="","MISSING BARCODE",IFERROR(INDEX('Asset Info'!$B$2:$B$10,MATCH(IF(LEFT(B2,4)="CN02","CN02",LEFT(B2,10))&"*",'Asset Info'!$A$2:$A$11,)),"None in Asset Info"))
Hi Bo_Ry,
Thanks! Really appreciated.
Hi Bo-Ry,
One slight adjustment.
How do I get it to display "LEDGER" if it match "CN02". Thanks!
-Gim
File from Post#2
Asset!C3 already display "LEDGER"
You may try C2
=IF(B2="","MISSING BARCODE",IF(LEFT(B2,4)="CN02","LEDGER",IFERROR(INDEX('Asset Info'!$B$2:$B$10,MATCH(LEFT(B2,10)&"*",'Asset Info'!$A$2:$A$11,)),"None in Asset Info")))
Hi Bo_Ry,
I have a smiliar situation. Do you mind assisting? Thanks!
-Gim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks