blonde poker forum

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!

you can use VLookup in the first square that doesn't have a value, then drag this formula down (bottom right corner little box when you hover over the square use the +) to the rest of the squares you want to fill.

then as you say use a copy paste as values to provide the numbers not the forumla to export.


more info and a step by step guide that seems simple enough to understand here -

https://www.laptopmag.com/articles/excel-2013-vlookup



edit im confused column A seems the same as column N does this change further down?



edit 2 so currently H 1 = O 1, H 2=O 2 H 3=O 3 etc




edit 3 ok so yeh you acknowledge that, so my original answer stands.

In H2 try

=VLOOKUP(A2, N:O, 2, 0)

If that works, drag it down and if that all looks good, copy and paste values over the top to get rid of the formula once it's done its job.

That's great, thanks chaps.