Forum Discussion
VFernandes
May 28, 2025Copper Contributor
Return values from a Range
Hello there. Help needed please. If I have a range number of parts to stock (Column A and Column B), I would like to calculate the number of hours for maintenance and Initial Setup Time. Example if...
HansVogelaar
May 29, 2025MVP
My apologies - it was a typo. The ranges should be the same size.
=XLOOKUP(F2, A3:A13, C3:D13, "", -1)
VFernandes
May 29, 2025Copper Contributor
Excellent, it works.
Apologies I also missed the typo.
Thank you very much for your quick and excellent support, much appreciated.