Vlookup loop

Hi

I have spreadsheet that runs through a macro on a dailly basis, however, I have noticed a problem with the VLOOKUP in the macro as it is failing to pick up some of the results due to the Range Data moving with each row it passes through.

The VLOOKUP if processing normally in Excel would be

=VLOOKUP(C3,FundList!$A$2:$B$301,2,0)

However, when running through the code it is adding on a row as if the "$" was not being used.

My VBA code is (which is obviously not working is)

"=VLOOKUP(RC[-13],FundList!R[-1]C[-15]:R[298]C[-14],2,0)"

My Range that I need to use is in a sheet named FundList and is from A2:B300

My main sheet is "MF"

Any help would be greatly appreciated.

Thanks

Maybe

Please Login or Register  to view this content.

VBA Noob

The search criteria in Column 3 changes with everyrow.

So I do not always want to use C3.

How do I change this so that it searches the result from

C3
D3
E3

etc etc

I have now resolved this issue:

x = 1

Please Login or Register  to view this content.

Thanks

Good to see but please remember to use code tags as per the forum rules below

VBA Noob