Close

Results 1 to 4 of 4
  1. #1
    DF VIP Member DJ OD's Avatar
    Join Date
    Jul 2001
    Location
    On da decks.
    Posts
    10,114
    Thanks
    1,008
    Thanked:        2,254
    Karma Level
    1103

    Default Another Excel Formula problem...

    FFS. I just can't get my head around this bastard formula.

    Pretty sure I've done it before or similar using VLOOKUP and OFFSET or INDEX or summot.

    Basically if you look at the attached sheet, all I want to do it populate the cells in the yellow and blue boxes (Column N) with the values in column G. First checking column A to see it matches column L and then checking colume B with column M.

    So where it says B then T06 it will return 1000
    Or where it says H then T44 it will return 27000

    Anyone help me out?


    DJ OD
    Attached Files Attached Files

  2. #2
    DF VIP Member cassy34's Avatar
    Join Date
    Nov 2004
    Location
    Lytham
    Posts
    1,453
    Thanks
    246
    Thanked:        181
    Karma Level
    358

    Default Re: Another Excel Formula problem...

    Hi DJ,

    Easiest way to do this is to insert a new column (C) and in C3, enter the formula =A3&B3
    copy this down to the last row.

    To get the values in column O (was N) enter the fomula
    =VLOOKUP(M3&N3,$C$3:$H$27,6,0)
    again, copy this where needed.

    You can then hide Column C to keep things tidy.

    HTH

  3. #3
    DF VIP Member Swiss Tony's Avatar
    Join Date
    Apr 2004
    Location
    NCP MK
    Posts
    3,517
    Thanks
    1
    Thanked:        21
    Karma Level
    502

    Default Re: Another Excel Formula problem...

    =IF(AND($A3=$L3,$B3=$M3),G3,"Error") - this is the first one for A, but get my jist ?

    =IF(AND($A4=$L4,$B4=$M4),G4,"Error") - Column B etc.... the $ denotes so that the columns stay the same during cut and paste!
    Losing Gracefully Since September 2010

  4. #4
    DF VIP Member DJ OD's Avatar
    Join Date
    Jul 2001
    Location
    On da decks.
    Posts
    10,114
    Thanks
    1,008
    Thanked:        2,254
    Karma Level
    1103

    Default Re: Another Excel Formula problem...

    Quote Originally Posted by cassy34 View Post
    Hi DJ,

    Easiest way to do this is to insert a new column (C) and in C3, enter the formula =A3&B3
    copy this down to the last row.

    To get the values in column O (was N) enter the fomula
    =VLOOKUP(M3&N3,$C$3:$H$27,6,0)
    again, copy this where needed.

    You can then hide Column C to keep things tidy.

    HTH
    That's spot on mate.

    Sorted now. I actually added the extra column before column A as I'd be pasting that raw data in from a csv file, adjusted the column reference from 6 to 8 and it worked a treat.

    Thanks Swiss as well ;-)


    DJ OD

Similar Threads

  1. Floppy problem
    By urbsy in forum PC Problems
    Replies: 8
    Last Post: 7th September 2002, 12:04 AM
  2. Formula farce
    By 4me2 in forum General Sports
    Replies: 17
    Last Post: 31st August 2002, 03:31 PM
  3. F12002 Problem
    By shawtek in forum Microsoft Consoles
    Replies: 9
    Last Post: 31st August 2002, 10:20 AM
  4. Problem with Compaq Armada E500 Laptop
    By Mr Olympia in forum PC Problems
    Replies: 2
    Last Post: 29th August 2002, 02:40 PM
  5. real audio recording problem
    By flypitcher in forum Music Factory
    Replies: 3
    Last Post: 28th August 2002, 11:25 PM

Social Networking Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •