Matching values from Sheet1, returning value from Sheet2
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Matching values from Sheet1, returning value from Sheet2

  1. #1
    Guest

    Default

     
    I need a formula where on Sheet1 cells A10 and K3 have a value entered. I would like to look up the matching value on Sheet2, column A & B, then return the value from Sheet2 column C to Sheet1 cell D10.

    Appreciate any feedback.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi
    I assume you mean this:
    Look down column A in sheet2 to find the value equal to A10 (where the value next to it in column B is equal to K3), then return the value in column C.
    You could try this formula in Sheet1 D10
    =INDIRECT("Sheet2!C"&MATCH(A10&K3,Sheet2!D:D,0))

    This requires use of a hidden column in Sheet2. I have used column D:D
    Insert this formula in D1 and scroll down =A1&B1

    Hope this helps
    Regards
    Derek

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
  •  

 

 
DMCA.com