Seating Plan Lookup

[Jay_hl]

Hi All

Im looking to automate a way of working out which people are sat on which table. This is just a sub set of the larger data.

I cannot change the format of the seating plan, hence the names are spread across 10 columns and approx 20 rows.

Can anyone advise please?Excel Seating Plan Lookup.xlsx

Thanks

James

[etaf]

i used the formula based in this website - it maybe overkill for what you are looking for
=IFERROR(INDEX($C$2:$H$10, SMALL(IF($C$2:$H$10=L11, ROW($C$2:$H$10)-MIN(ROW($C$2:$H$10))+1, ""), ROW($C$2:$H$10)-MIN(ROW($C$2:$H$10))+1), COLUMN($C$2:$H$10)-MIN(COLUMN($C$2:$H$10))+1), "")

http://www.get-digital-help.com/2009...n-excel-table/

[sktneer]

Try this.....

In M11

Please Login or Register  to view this content.