C2:
=LOOKUP(2,1/('Item List'!$B$2:$B$3166=$B2)*('Item List'!$A$2:$A$3166=Serial_Number!$A2),'Item List'!$C$2:$C$3166)
and copy down
C2:
=LOOKUP(2,1/('Item List'!$B$2:$B$3166=$B2)*('Item List'!$A$2:$A$3166=Serial_Number!$A2),'Item List'!$C$2:$C$3166)
and copy down
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks