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...
@ 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