Forum Discussion
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 th...
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)
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)
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.