Hello! First time post here - I have been trying to sort this out with LOOKUP and/or IF functions but it does not seem to be working.
Something along the lines of this - If Sheet1!D3 = a value in Sheet2!A:A than display its respective value from Sheet2!B:B in Sheet1!J:J
Example attached. I'm looking for the "Code" from the Shown tab in the pricing tab and have its respective price into the price column (yellow cells).
Any help is appreciated.
Bookmarks