ExcelBanter - Urgent help with a Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Urgent help with a Function (https://www.excelbanter.com/excel-discussion-misc-queries/48510-urgent-help-function.html)

Jeff

Urgent help with a Function

Hello,
Can anyone please help me with a VBA procedure that would run this
function from row F3 to the next empty row in column "C"

=INDEX([VBPA.xls]Sheet1!$D$1:$D$50000,
MATCH(1,(INT(D3)=[VBPA.xls]Sheet1!$A$1:$A$50000)*("BP"=[VBPA.xls]Sheet1!$C$1:$C$50000),0))

--
Regards,
Jeff

All times are GMT +1. The time now is 09:06 PM.