This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 12%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
How to get lookup column value to a calculated column .
Could you share the code that you have tried? Where exactly lookup is being done and where calculated column has to be added?
Hi RajShekar-3515,
Lookup columns cannot be referenced in a calculated column formula.
Supported and Unsupported Columns in SharePoint Calculated Column Formula
As a workaround, you can simply user workflow or event receiver to update the target column based on the lookup field. For more details, please refer to Using Lookup Field in Calculated Column SharePoint
Best Regards,
Baker Kong
Hi @Raj Shekar ,
Regarding this issue, Is there any other concern? Please feel free to talk with us if you have other SP related question, we're glad to help further.
Thanks
Baker Kong
Hi @Raj Shekar ,
Regarding this issue, we have not heard from you for a long time. If the above info is helpful to this question, it would be appreciated if you can mark it as an answer so that others who stuck in similar issues could get answered quickly.
And if you want to receive the related email notification for this thread, please follow the steps in our documentation to enable e-mail notifications.
Thanks
Baker Kong