Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Nested Functions-revised question

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Revised question from yesterday
    Work Sheet 1 looks like this:
    D3=4", F3=8", A11=8, C11=1977, F11=*, A12=8, C12=1984, D12=*; WHERE *=value to lookup from Work Sheet 2.
    Work Sheet 2 looks like this and is sorted in ascending order by columns A & B:
    A9=8, B9=1977, C9=8", D9=32
    A10=8, B10=1984, C10=4", D10=263
    The desire is to populate Work Sheet 1 with F11=32 and D12=263.
    I am assuming I will have to use nested IF, LOOKUP functions, but have been unable to get the right combinations, error free.
    Any help is greatly appreciated
    Randy

    [ This Message was edited by: rsw8679 on 2002-03-26 09:32 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here's something ugly but effective:

    On Sheet 2, insert a column D between C and old column D and populate it like this:
    D8: = A8 & B8 & C8

    Now, on Sheet 1, the cells on D and F would be:
    F11=VLOOKUP($A11&$C11&F$4,Sheet2!$C$2:$D$999,2,False)
    D12=VLOOKUP($A12&$C12&D$4,Sheet2!$C$2:$D$999,2,False)

    HTH


    _________________
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden


    [ This Message was edited by: Tim Francis-Wright on 2002-03-26 10:47 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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