Log In
Register
Home
December 24, 2018
Offline
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
October 5, 2010
Offline
Hi Salim,
Isn't this the same problem I answered here
https://www.myonlinetraininghu.....okup-value
Regards
Phil
December 24, 2018
Offline
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
1 Guest(s)
