=INDEX(Sheet1!$C$1:$C$300,SMALL(IF((Sheet1!$A$1:$A $300="X")*(Sheet1!$B$1:$B$
300="Y"),ROW(1:300)),1))

Enter with Ctrl+Shift+Enter rather than Enter.

This assumes there will only be one row that has X in A and Y in B.

--
Regards,
Tom Ogilvy

"amyacc " wrote in message
...
At a new job, there are multiple documents with "supposedly" similar
info that needs updating often. I'd like to create a master that
populates like fields in other documents.

Do you know if i can use an excel array formula to basically transpose
text? i.e.: If the title in column A = "X" and the partner in column
B = "Y" then take the details text from column C and paste it here.

Possible?

Please and thank you.


---
Message posted from http://www.ExcelForum.com/