getting data from a table

Joined
Dec 6, 2006
Messages
3
Reaction score
0
I have a table

Months01234567891011Days 0017434852269687010441217139115651739191316180354528702875104912231397157117451919212186360533707881105512291403157717511925317191365539713887106112351409158317571931423197371545719893106712411415158917621936529203377551725899107312461420159417681942635209383557731904107812521426160017741948741215388562736910108412581432160617801954846220394568742916109012641438161217861960952226400574748922109612701444161817911965105823240658075492811021275144916231797197111642384125867609331107128114551629180319771270244417591765939111312871461163518091983137524942359777194511191293146716411815198914812554296037779511125129914731646182019941587261435609783957113113041478165218262000169326744161578996211361310148416581832200617992734466207949681142131614901664183820121810427845262680097411481322149616701844201819110284458632806980115413281502167518492023201162904646388129861160133315071681185520292112229647064481799111651339151316871861203522128302475649823997117113451519169318672041231333074816558291003117713511525169918732047241393134876618351009118313571531170418782052251463194936678411015118913621536171018842058261513254996738461020119413681542171618902064271573315046788521026120013741548172218962070281623365106848581032120613801554172819022075291683425166908641038121213861560173319072081

I want to enter a number (509) and find the closest match, then enter the corresponding months and days. In this case 2 months 28 days.

I've tried hlookup, vlookup, index, match and can't seem to get the right combination.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top