+ Reply to Thread
Results 1 to 4 of 4

Look up function

  1. #1
    Registered User
    Join Date
    02-08-2006
    Posts
    3

    Red face Look up function

    I have a workbook with 2 worksheets (Sheet1) and (Sheet2). I need to look at (Sheet1) cell (AL3) if this cell is blank I then need to look at Cells (F3) and (G3) to determine which row I need to use in (sheet2).

    I would be greatful for any help

    Simon

  2. #2
    Bernard Liengme
    Guest

    Re: Look up function

    Can you elaborate on
    "I then need to look at Cells (F3) and (G3) to determine which row I need to
    use in (sheet2)" ?

    Give us one or two examples of values in F3 and G3 and what happens next.
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "swestwood" <swestwood.24cwza_1141831203.9534@excelforum-nospam.com> wrote
    in message news:swestwood.24cwza_1141831203.9534@excelforum-nospam.com...
    >
    > I have a workbook with 2 worksheets (Sheet1) and (Sheet2). I need to
    > look at (Sheet1) cell (AL3) if this cell is blank I then need to look
    > at Cells (F3) and (G3) to determine which row I need to use in
    > (sheet2).
    >
    > I would be greatful for any help
    >
    > Simon
    >
    >
    > --
    > swestwood
    > ------------------------------------------------------------------------
    > swestwood's Profile:
    > http://www.excelforum.com/member.php...o&userid=31323
    > View this thread: http://www.excelforum.com/showthread...hreadid=520108
    >




  3. #3
    Bernard Liengme
    Guest

    Re: Look up function

    Can you elaborate on
    "I then need to look at Cells (F3) and (G3) to determine which row I need to
    use in (sheet2)" ?

    Give us one or two examples of values in F3 and G3 and what happens next.
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "swestwood" <swestwood.24cwza_1141831203.9534@excelforum-nospam.com> wrote
    in message news:swestwood.24cwza_1141831203.9534@excelforum-nospam.com...
    >
    > I have a workbook with 2 worksheets (Sheet1) and (Sheet2). I need to
    > look at (Sheet1) cell (AL3) if this cell is blank I then need to look
    > at Cells (F3) and (G3) to determine which row I need to use in
    > (sheet2).
    >
    > I would be greatful for any help
    >
    > Simon
    >
    >
    > --
    > swestwood
    > ------------------------------------------------------------------------
    > swestwood's Profile:
    > http://www.excelforum.com/member.php...o&userid=31323
    > View this thread: http://www.excelforum.com/showthread...hreadid=520108
    >




  4. #4
    Westaradg
    Guest

    Re: Look up function

    I agree with Bernard Liengme a clarification is necessary, but it sounds like
    your trying to combine a (vertical lookup) with an (if statement), try this
    link towards the bottom of the page.
    http://www.contextures.com/xlFunctions02.html

    "Bernard Liengme" wrote:

    > Can you elaborate on
    > "I then need to look at Cells (F3) and (G3) to determine which row I need to
    > use in (sheet2)" ?
    >
    > Give us one or two examples of values in F3 and G3 and what happens next.
    > best wishes
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1