Forum Discussion

Copper Contributor

Nov 08, 2023

VLOOKUP Between two CSV files

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-...

PSR2-2023-11-08.csv1.2 MB

products-2023-11-08.csv3.9 MB

excel

Formulas and Functions

Patrick2788

Silver Contributor

Nov 08, 2023

Luke_Hively

Try this one:

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