Dear everyone
i have a problem that, there are number of days from day one to last day of 20 year, each day have different rate of percentage, to check rate of particular days rate, i want to a formula which make it easy, if any number put into one cell other cell show its rate, how it will be possible, please guide me
Hi Salim,
Isn't this the same problem I answered here
https://www.myonlinetraininghub.com/excel-forum/excel/how-to-lookup-value
Regards
Phil
Dear Sir
no doubt your said formula is useful but it is not working as i want, vlookup formula cover only two column, here i need to check rate of number of days of 20 years means 7300 separate numbers each column represent only days of one year, 365 days in one column second column start from 366 to 730, i want to check rate of particular number from the sheet as per above
Hi Salim,
Maybe rearranging your data so that it is in a format that will work with the functions in Excel is a better solution than requiring a complicated formula to suit your data?
Regards
Phil
