Filling a table with uniuqe store ID's

[lkim]

I am trying to match different stores’ fruit inventories to their own store IDs. For example, all the fruits sold at Sunny’s would get “101”, from J&T would get 201, etc. I have Table 1 and Table 2 and am trying to fill Table 2 cells so that it looks like Table 3 (please see attached worksheet).

Thanks!

[Haseeb Avarakkan]

Try this, F4, copy down & across

=IF(COUNTIF(INDEX($A$5:$C$10,0,MATCH(F$2,$A$3:$C$3,0)),$E4),F$3,"")

[lkim]

Thank you. That works great!