Help to find get items from a list to another
I have a transaction form which has two line items lets say A,B (both text) -> Concatenating A,B gives C
Row 1 of A -> SDF AB9
Row 1 of B -> 20
Row 1 of C -> SDF AB9 - 20
I have another list which basically have some items of A, B column and i manually concatenate and upload in Code column to get C
It's number list BTW
My goal is to get a True in Transaction form if the item present in the list combination (C).
Currently i'm using Finditem formula but client don't want to do manually concatenate A,B column and upload in Code.
So i need help in following things : -
1. Is there a way that Find-item can work on concatenate column with A,B columns data ?
2. Is there a way to get data into Code column in list with some formula or something ? -> I know it's possible but just a search
3. Any other possibility or best practice to handle this situation?
Thanks and Regards,