Hi everyone!
Basically, I have two .csv files. Each file has TWO columns "SKU" AND "Quantity".
When I open file #2, I need to Lookup matching SKU values in file #1, and return matching Quantity values. In other words, I need make sure that QUANTITIES are the same for both files with related SKU.
The problem I am facing in creating the formulas is, both files are .csv and they are Two different files, not just tabs in one file.
Helps and suggestions are greatly appreciated!
In file #2, use this formula starting in C2 and fill down (I am assuming row 1 has headers and your data starts in row 2)
Formula:
Please Login or Register to view this content.
Replace "File 1" with the actual file name (in both places).
(Note: To save the formulas in File 2, you will have to save it as a .xlsx file.)
I created two files that matched your description with the SKU in column A of both files and the Quantity in column B. The file with the formula cannot be a CSV file and maintain the formulae because a CSV file is really a text file.
In File 2.xlsx (Excel file to keep the formulae)
Enter in B2 and fill down:
Formula:Please Login or Register to view this content.
Alternately, you can use this formula in B2 and fill down:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you so much, this formulas is working perfectly =VLOOKUP(A2,'[File 1.csv]File 1'!$A:$B,2,FALSE)
I need an advice, when I drag down the formula, missing fields show #N/A"... I would like them it remain BLANK.. what should I do ?
What do you mean by "missing fields"? Data in File 2, where the formula is, is blank? Or the information you are trying to find in File 1 is not there?
To deal with both types of errors use this formula:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks