Forum Discussion

StevenWBlack's avatar
StevenWBlack
Copper Contributor
Dec 31, 2019

Lookup data from another list (2 columns)

I have a primary list that has 2 lookup fields for airport codes.  I need to copy a value from another list that contains both lookups field values and (returning the cost).  I am unsure how to do this.  Calculated column; workflow, etc?  Please advise.

2013

2 Replies

Sort By
  • ellan1537's avatar
    ellan1537
    Iron Contributor
    Dec 31, 2019
    If you're using 'Currency' column type for look up, then it is not supported in lookups. You would have to make that a number or text column instead. Or, you could create a workflow/calculated column to transfer the currency values to another number or Text column in the source list, then create a lookup from destination list to that.

    Hope this helps!

    For your information:
    Columns available as lookups: Title, Single Line of Text, Number, Date and Time, ID, Modified, Created, Version
    Columns NOT available as lookups: Multiple Lines of Text, Choice, Currency, Yes/No Check Box, Person or Group, Hyperlink or Picture, Managed Metadata (Term Store)
    • StevenWBlack's avatar
      StevenWBlack
      Copper Contributor
      Jan 03, 2020

      ellan1537 

      I'm stuck on the lookup function.  I need to figure out how to find the correct list item that contains both lookup fields then I will know what to copy over.  There has to be some way to tell it to find the list item that contain "Lookup item 1" and "Lookup item 2" then to copy column "M" from that list.

Resources