12 Replies Latest reply on Oct 30, 2018 5:31 AM by Deepak Rai

    Pulling field based on Text from another (similar to VLookup)

    Terri English

      Hi All

       

      I think there maybe multiple ways to do this but not sure where to start.

       

      So Example is as follows :-

       

      Field A     :    'Server'    (eg. Server 1)        

       

      Field B     :    'Storage'  (eg. Storage 1)

       

      Field C     :    'Storage'   (eg. Storage1) - This is a manipulated text field where I've manipulated the text to look like Field B by splitting another field.

       

      I would like to created Field D which would look at the text in Field C and pull the matching record from Field B (similar to VLOOKUP in Excel), how would I do this ?

       

       

      Thanks in advance