Hi,
I'm trying to match item numbers in the inventory tab with the item numbers in the BT tab using the description title as the common thing. I have added a column called BT Itme number on Inventory tb as this is where i want to display the item number from BT tab.
Problem is the description details in Inventory tab is different from the description in BT tab.
I'm trying to get a formula that allows e to do this without doing it row by row (item by item) like i have done on cell D34 & D49 on Inventory tab.
Appreciate any assistance.
Regards,
Lidoxy
Bookmarks