Hi,
I am not sure if it can be done with simple formula.. I tried to build logic but could not understnad it. All I want is Master sheet C2 value get the data from Raw sheet.
E.g :
C2 should fetch data from Raw sheet based on C2 value and update if it found. Like in attached example, D2 should displayed "Pune" but it is coming as #N/A
Here is the attachment.
Bookmarks