VLOOKUP Between two CSV files

[Luke_Hively]

Hello, 

I am trying to use a vlookup function to between two of my workbooks to insert the price into column I in the products 2023 workbook. My current formula is 

=VLOOKUP(E2,'PSR2-2023-11-08.csv'!$A$2:$G$199228,7,FALSE)

I'm am unsure of what the problem, I use the function pretty regularly and it may come down to formatting. Any suggestions would be appreciated. Thank you 

[#2]

@Luke_Hively 

Try this one:

=IF(ISBLANK(E2),"",VLOOKUP(E2,'PSR2-2023-11-08.csv'!$B$2:$G$199228,6,0))