Lookup a value

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Re: Lookup a value


    If I have cf in a cell, in the next cell to the right I want to put a function
    to lookup cf (it's in col 3, row 4) and return 18b (from col 9, row 4)


    [TABLE="width: 664"]

    [tr]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [td]

    3

    [/td]


    [td]

    4

    [/td]


    [td]

    5

    [/td]


    [td]

    6

    [/td]


    [td]

    7

    [/td]


    [td]

    8

    [/td]


    [td]

    9

    [/td]


    [/tr]


    [tr]


    [td]

    mb

    [/td]


    [td]

    name

    [/td]


    [td]

    km

    [/td]


    [td]

    name

    [/td]


    [td]

    kh

    [/td]


    [td]

    name

    [/td]


    [td]

    cc

    [/td]


    [td]

    name

    [/td]


    [td]

    1a

    [/td]


    [/tr]


    [tr]


    [td]

    lew

    [/td]


    [td]

    name

    [/td]


    [td]

    bh

    [/td]


    [td]

    name

    [/td]


    [td]

    bmy

    [/td]


    [td]

    name

    [/td]


    [td]

    cb

    [/td]


    [td]

    name

    [/td]


    [td]

    1b

    [/td]


    [/tr]


    [tr]


    [td]

    dk

    [/td]


    [td]

    name

    [/td]


    [td]

    bc

    [/td]


    [td]

    name

    [/td]


    [td]

    br

    [/td]


    [td]

    name

    [/td]


    [td]

    my

    [/td]


    [td]

    name

    [/td]


    [td]

    18a

    [/td]


    [/tr]


    [tr]


    [td]

    mc

    [/td]


    [td]

    name

    [/td]


    [td]

    cf

    [/td]


    [td]

    name

    [/td]


    [td]

    ema

    [/td]


    [td]

    name

    [/td]


    [td]

    rv

    [/td]


    [td]

    name

    [/td]


    [td]

    18b

    [/td]


    [/tr]


    [tr]


    [td]

    bf

    [/td]


    [td]

    name

    [/td]


    [td]

    mt

    [/td]


    [td]

    name

    [/td]


    [td]

    gz

    [/td]


    [td]

    name

    [/td]


    [td]

    er

    [/td]


    [td]

    name

    [/td]


    [td]

    17

    [/td]


    [/tr]


    [tr]


    [td]

    cs

    [/td]


    [td]

    name

    [/td]


    [td]

    me

    [/td]


    [td]

    name

    [/td]


    [td]

    pk

    [/td]


    [td]

    name

    [/td]


    [td]

    bm

    [/td]


    [td]

    name

    [/td]


    [td]

    16

    [/td]


    [/tr]


    [tr]


    [td]

    ew

    [/td]


    [td]

    name

    [/td]


    [td]

    rck

    [/td]


    [td]

    name

    [/td]


    [td]

    gr

    [/td]


    [td]

    name

    [/td]


    [td]

    vk

    [/td]


    [td]

    name

    [/td]


    [td]

    15a

    [/td]


    [/tr]


    [tr]


    [td]

    gwy

    [/td]


    [td]

    name

    [/td]


    [td]

    kc

    [/td]


    [td]

    name

    [/td]


    [td]

    rc

    [/td]


    [td]

    name

    [/td]


    [td]

    rb

    [/td]


    [td]

    name

    [/td]


    [td]

    15b

    [/td]


    [/tr]


    [tr]


    [td]

    bk

    [/td]


    [td]

    name

    [/td]


    [td]

    wm

    [/td]


    [td]

    name

    [/td]


    [td]

    he

    [/td]


    [td]

    name

    [/td]


    [td]

    hp

    [/td]


    [td]

    name

    [/td]


    [td]

    14

    [/td]


    [/tr]


    [tr]


    [td]

    a

    [/td]


    [td]

    name

    [/td]


    [td]

    b

    [/td]


    [td]

    name

    [/td]


    [td]

    c

    [/td]


    [td]

    name

    [/td]


    [td]

    d

    [/td]


    [td]

    name

    [/td]


    [td]

    13a

    [/td]


    [/tr]


    [/TABLE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login