Howdy,
I've cocked up in a spreadsheet and could use some help if possible. It's a combination of two spreadsheets and was all going well until I deleted some rows in this one making all the values I hadn't copied over a few rows out.
In column H I need to put a sale price. It needs to get the product code from column A, look it up in column N and return the price in column O, is this possible? The prices look right on this screenshot but further down they're out hence the need for a lookup of some sort.
I also need it as a number rather than a formula as I want to upload it as a csv so I guess I should make a new column to return the values then copy and paste values only?
Hope that makes sense
Thank you
I'm not very good at Excel!