I have a requirement to add a column to a document library, that is a lookup to an existing list There is already a column (A) in this document library that looks up a field from the list. The column to be added (B) needs to be a lookup to the same list and if possible, be relational in that it will contain the value that corresponds to (A)'s value in the lookup list. My initial reaction would be that this isn't possible, but i wanted to check in case it was. Hope this makes sense Thank you A

Swan Traditionally, you can accomplish combining two columns named Column1 and Column2 using the following formulas: =Column2&","&Column1 However, since one of the columns is a lookup column, the above approach will not work for calculated columns. Trying this, you will get the following error message: One or more references are not allowed, because the columns are defined as a data type that is not supported in formulas. Read About displaying totals and calculated columns [http://office.microsoft.com/en-us/sharepointtechnology/HA011611541033.aspx] and Examples of common formulas

Hi Kanwal Thank you for your assistance. I think you may have kind of answered my question, but i not looking to combine both columns but almost perform a lookup on an existing lookup column, I dont think it is possible. Anyone else can confrim this for me?

Swan_E, I think the title of your posting may cause some confusion - apparently what you're looking to do has nothing to do with a calculated column. Anyway, to answer your question, no it is not possible OOB to link two lookup columns in such a way that one is based on the other. Perhaps if you provide a little more detail about your two lists and what you're trying to accomplish someone might be able to offer an alternative solution? Chanda

Hi, Yes, it is impossible in OOTB environment. You can consider using web part connection feature to link the document library and the list as follows: 1) Create a lookup type field referring to the field of your list in your library. 2) Create a web part including your library in the page. 3) Create another web part including your list side by side in the same page. 4) Create a connection between two web parts using lookup type field. Hope it is helpful! Seven

Many thanks