I'm not sure where to begin.

[djwaffle]

Please help. . . . .
So I have some spreadsheets with various values in them and with some 1500 rows I need a faster way to do this report every month.

IPsheet.pngbilling-sheet.png

Here is what I'm trying to do. I need to search the billing sheet for the IP from the IP Sheet (col. A) and paste the most recent date and time from (col. E) into (col. C) on the IP sheet. these are different files and the real billing file is over 200mb and growing. .

I am open to any suggestions anyone may have.

Thank you. . . William

[aetedford]

Like a vlookup?

[JasonLeisemann]

Ah... I think I see why VLookup wouldn't work for you, since you need the latest timestamp and could have multiple options.

Maybe give this a shot?

Please Login or Register  to view this content.

Not sure how the time factor will work out for you. There are probably more elegant ways to do it, but this should be a workable brute-force option once everything's put in.

[mike7952]

Can you upload your example in a workbook, its hard to mockup a workbook to test on from pics.

[arlu1201]

Djwaffle, welcome to the forum.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.