Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Need help finding specific MS Excel Function.

DukiDuki Registered User regular
edited May 2008 in Help / Advice Forum
This is retarded. I can't find anything similar to this at all and it's driving me crazy. What it needs to do is match a number from a cell to a number in a table and show two corresponding columns in the same row with the results separated by a space.

Or something. Fuuuuuuuuuck.

Duki on

Posts

  • Bliss 101Bliss 101 Registered User regular
    edited May 2008
    If CELL is a reference to the value you're looking for, and TABLE is the table you need to search in, and X and Y are the numbers of the two columns you want to pick up:

    =CONCATENATE(VLOOKUP(CELL; TABLE; X; FALSE);" ";VLOOKUP(CELL; TABLE; Y; FALSE))

    So it does two VLOOKUP searches to find the two columns you need. The CONCATENATE() command merges them into one string, separated by a space (the " " in the middle).

    Note that I used semicolons to separate the parameters because that's how my version of Excel rolls. Yours are probably commas.

    Bliss 101 on
    MSL59.jpg
  • DukiDuki Registered User regular
    edited May 2008
    Perfect, thanks a lot man. Saved my ass <3

    Duki on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum