INDEX, MATCH and Return an Array?? Or something like that...

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

[Hi Glenn!

There's one more thing I want to add... a cell next to the output table that tells the user what the tray in question "tray 1 read 1" was originally labelled in the data (on the left where it says Test tray: 1 etc)... if that makes sense?

Cheers,
P]

Actually, scratch that... I've hit an issue with the original formula. Sometimes there are blank cells in the raw data or values ending in * which need to be processed slightly differently. I am performing a calculation on the data in the output table, based on whether F8 (or any cell in that table) is blank, contains a * or contains a numerical value. =IF(ISBLANK(F8),"Missing",(IF(ISNUMBER(SEARCH("~*",F8)),"MARKED",(((top secret maths calculation/irrelevant)))). However when I populate the output table using the method you kindly provided before, this formula doesn't behave the way I need it to. Is there another way to identify blank cells and *'s in the output table as per the previous solution. Or can the previous solution be modified to allow for this?

Many thanks

Phoebe