Forum Discussion

VonJoe24's avatar
VonJoe24
Copper Contributor
Aug 11, 2023
Solved

Help with excel function/formula

 I need help to look up the Completion date (Coaching Raw sheet) based on the reference ID. The raw sheet contains 3 columns where we can find the possible reference ID with its corresponding complet...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Aug 11, 2023
    if those ref IDs are unique it may be easier to use that column A:
    =XLOOKUP("*"&a2:a100&"*", Raw!a2:a100, Raw!f2:f100,"",2)
mtarler's avatar
mtarler
Silver Contributor
Aug 11, 2023
if those ref IDs are unique it may be easier to use that column A:
=XLOOKUP("*"&a2:a100&"*", Raw!a2:a100, Raw!f2:f100,"",2)
VonJoe24's avatar
VonJoe24
Copper Contributor
Aug 12, 2023

mtarler it works! Thank you! Appreciate the help!

Resources