Hi all I am really struggling with creating a formulae. Wondering if anyone had any ideas?
What I am trying to do:
Based on asset tag column in sheet 1 bring in the expiry date of an asset from column 2 in sheet 2. The common element or index being in column 1 (asset tag). I need to do this as I have several thousand assets in one sheet already edited and need to bring in expiry date of assets from a separate sheet. I have attached a test spreadsheet.
Thanks
Bookmarks