Forum Discussion
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...
The values in column A and B are currently text values. Convert them to numbers, and change A13 to the number 101.
In F7:
=XLOOKUP(F2, A3:A13, C2:D13, "", -1)
This will spill to F7:G7.
Hi Hans,
Thank you very much for your assistance.
I have tried using your suggestion but somehow it is not working. Any thoughts please.