Forum Discussion
XLOOK-UP greater than
Hi, I have the attached workbook, and I have 2 problems:- 1) I need to create a lookup (hopefully X) which will return multiple columns, say F & J, if their age is greater than a value in act...
Robert1290 With regard to point 2:
=ROUNDDOWN(((TODAY()-I5))/365.25,0)
You take the formula from H5, without the = sign, and place it in the ROUNDDOWN function in stead of H5.
Not sure what you want in point 1.
@ Riny_van_Eekelen thank you, that is so obvious now you have said it, and will help me in the future with other formulas.
For point 1, say if the actual age is more than 40, then I would like to return, say, their name and reference on to a new worksheet.
Robert1290 If your Excel version supports it you can use the FILTER function. Otherwise, a simple pivot table could do it. Both demonstrated in the attached file on Sheet2