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