Match value in row and the find specific value in that table
Results 1 to 3 of 3

Thread: Match value in row and the find specific value in that table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Feb 2012
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Match value in row and the find specific value in that table

    https://screenshot.net/r4rlxf1

    Hi,

    this should be easy but I can't seem to find the solution.

    See attached picture on top of the page (couldnn't add it as a picture in the post?). First I need to find the ID in column B base on values in N5-N7. The I want it to return the lastest salary possible. The problem here as you can see is that the amount of rows is not the same in each table but there are always an empty row after the last row in each table.

    So the resault I want is in O5-O7. I alreday have the ID, so for ID 790101 I want the salary 22 850 to be in O5 which can be found in cell E29? How can I do that? Also the will be a lot of rows (probably 50.000-100.000).

    /Per

  2. #2
    New Member
    Join Date
    Feb 2012
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Match value in row and the find specific value in that table

    I can ofcause use index match but the I'll only get to the row of the ID. How do I calculate number of rows bellow (in this case) the ID until next empty cell so I get the last row in that specific table?

    /Per
    Last edited by Bpuad; Jul 8th, 2019 at 09:28 AM.

  3. #3
    New Member
    Join Date
    Feb 2012
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Match value in row and the find specific value in that table

    Solved

Some videos you may like

User Tag List

Tags for this Thread

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
  •