Formulas and functions

[VroomVroom]

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]

@VroomVroom 

Does this do what you want?

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

[#3]

HI All if you want a detail of of SharePoint file and folder you can visit our website https://www.dokacademy.com/bootcamp-vba-filefolder we have uploaded compile file and folder codes you want watch video in Hindi on YouTube, https://youtu.be/O9jG_H7Fw8U 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 ,