blonde poker forum
Welcome, Guest. Please login or register.
March 28, 2024, 04:27:47 PM

Login with username, password and session length
Search:     Advanced search
2272476 Posts in 66752 Topics by 16945 Members
Latest Member: Zula
* Home Help Arcade Search Calendar Guidelines Login Register
+  blonde poker forum
|-+  Community Forums
| |-+  The Lounge
| | |-+  Excel Help
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Excel Help  (Read 1149 times)
Graham C
Hero Member
*****
Offline Offline

Posts: 20678


Moo


View Profile
« on: June 16, 2017, 12:37:30 PM »

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 Smiley  I'm not very good at Excel!
Logged

titaniumbean
Hero Member
*****
Offline Offline

Posts: 10048


Equity means nothing.


View Profile WWW
« Reply #1 on: June 16, 2017, 12:44:52 PM »

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.
« Last Edit: June 16, 2017, 12:50:32 PM by titaniumbean » Logged
AndrewT
Global Moderator
Hero Member
*****
Offline Offline

Posts: 15493



View Profile WWW
« Reply #2 on: June 16, 2017, 12:53:04 PM »

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.
Logged
Graham C
Hero Member
*****
Offline Offline

Posts: 20678


Moo


View Profile
« Reply #3 on: June 16, 2017, 01:01:51 PM »

That's great, thanks chaps.
Logged

Pages: [1] Go Up Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.076 seconds with 20 queries.