Hi everyone, here is my challenge. I have a spreadsheet with various tabs. One tab contains a list of equipment, each row is a different piece of kit (different record). Column A contains each item's unique code and Column B contains its description. On a different tab of the same spreadsheet I need to be able to enter an item code in one cell (lets say A1) and somehow perform a search in the list of kit (on the other tab) and return its description on the cell next to it (let's say B1). I know I can not run a macro as part of a function in Excel. Any suggestions please as to how I could achieve this? Many thanks