Dear All,
Good Afternoon!!!!
I'm using a formula to lookup a value in which I'm refering a cell upto 38 rows & then cell to be refered the next cell after these 38 cells
Ex: A4 has Delhi, A5:A38 has some values, A39 has Faridabad, A40:A73 has some values
Formula is being populated in B column in which I want to refer the Delhi from B5:B38 & then from B40:B73 to refer the Faridabad
Is it possible? Please confirm.
Bookmarks