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

Bpuad

New Member
Joined
Feb 17, 2012
Messages
36
Office Version
  1. 2019
Platform
  1. Windows
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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
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:
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top