gt;>
>> I also added an indicator to the Data sheet to see which PRF is selected
>> (for testing purposes)
>>
>> Hope this helps.
>>
>> *Paul*
>> -----------------
>>
>>
>>
>>
>>
>>
>>
>> *“Do all the good you can,By all the mean
s you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* SridharBL
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, July 21, 2015 7:39
ley
-------------
From: SridharBL
To: excel-macros@googlegroups.com
Sent: Tuesday, July 21, 2015 7:39 AM
Subject: $$Excel-Macros$$ Formula to Display Latest PO number Using date and
emp ID
Dear Friends,
I need help in creating the formula in attached file.
Dear Friends,
I need help in creating the formula in attached file.
In attached sheet. I have Sheet9 and Data Sheets.
In Sheep 9, If I type the Emp ID in the cell, its should look for data in
Data sheet for the Emp ID and Latest Date for in column ""Period To" and
get the New PO number that w