Help for the correct formula

Hi there

I am relatively new to this so any help would be greatly appreciated.


I am analysing a psych experiment


I have an output table/grid with approx 50k rows, as it describes every trial a participant (N=98) performed, there are therefore many rows of the same participant's data.

I also have a table/grid of mean data per participant therefore 98 rows. In this table there is a value which I want to bring over to the first table, that of "high exclusion". I would like this value to be repeated for every row corresponding to that participant's ID.

(I will try to include a picture.)
-Edited to include a sample spreadsheet


There are repeated rows with the same ID in the left table.
I would like to have the High Exclusion values (yellow), corresponding to individual's ID's (orange) copied over from the table on the right to the table on the left.

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.


The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

=index($h$2:$h$11,match(a2,$e$2:$e$11,0))

you are welcome