Lookup value and get minimum value of date in that found row

[martinhansen]

Hi

I'm quite new to this VBA programming in Excel. I have a very specific problem where I need some help. I hope you are the people ;-)

I have a workbook (Report) from where the cell B2 have to be looked up in column A in the workbook Project_Overview. The lookup have to return the lowest and the highest date from the row in where the value is present.

Pretty pretty please, can somebody help me?!

[Kaper]

In some cell in Report use:

Please Login or Register  to view this content.

and second formula with MAX instead of MIN.

[martinhansen]

Hi Kaper

Thanks. It works. Can anyone then help me doing it in VBA?

[Kaper]

in your Report.xlsm (and while sheet1 is active)

Please Login or Register  to view this content.

shall do the same

[martinhansen]

Thanks a lot! I think it works - now I just have to transfer it to my large documents.. I'm really happy you could help Kaper!!

[martinhansen]

Hi again

Is it possible to change the code so that B2 is found only in column B and C (and not column D)?

I really hope you can help a novice Thanks in advance!!!

[martinhansen]

Nobody that can help me?

I want to look up a value in five specific columns in the row returned by a match function.

[martinhansen]

I made a workaround, however it is not preferable when working on huge workbooks.. So if anyone have an idea to remove this workaround and make a generic solution, I would be happy to hear from you.

My workaround:

Please Login or Register  to view this content.

The reason for specifying Sheet1 is that I have to transfer the code to a large workbook.

[Kaper]

Hi,
the reply below is for your two yesterdays posts (just edited in one place to make it better applicable to your case shown today some 20 minutes ago).

1) five specific columns is a bit :-P different than column B and C (and not column D)
the latter below:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

the first (if these are really different (say B:D M and Z) columns) for instance (this you could easily adopt to your needs):

Please Login or Register  to view this content.