Formulas and functions

Copper Contributor

Hi Iam trying to fill individual cells but to do so for example A1 is the input cell i would like the formula to refer to the data validation for the table name and in descending order search for the value >= to A1 and the return value is A1+the adjacent cell of the >= match using no macros or vba

2 Replies


Does this do what you want?


=A1+XLOOKUP(A1, Table1[Column 1], Table1[Column 2], 0, 1)

HI All if you want a detail of of SharePoint file and folder you can visit our website we have uploaded compile file and folder codes you want watch video in Hindi on YouTube, If you want to us to upload video in English, please go to YouTube and subscribe us and write your demand on which topic you want us to upload Video ,