How to dynamically search and update data using multiple files [closed]

asked 2012-10-03 18:43:01 +0100

anonymous user


Not sure if this is even possible, but here goes.

I have three csv files. The first file, contains user data in a series of columns. One field is a userid. I need to search the second file, containing data about each user, for the specific userid. Once i have established this, i need to search a 3rd file for that user's name/email, which is a column in the first file, and take a column from that row, and place it into the second csv file, about 22,000 times.

Yeah that pretty much sums it up. I was going to load these files into mysql and perform the automation there, but wanted to check if there was a way of doing this in LO first.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-03-11 09:50:43.300752


Do you mean the formulas of this kind - =VLOOKUP(VLOOKUP(A2;$Sheet1.$A$2:$B$22000;2;0);$Sheet3.$A$2:$B$22000;2;0)? Yes, Calc can do this task. Although it will take some time

JohnSUN gravatar imageJohnSUN ( 2012-10-04 17:12:52 +0100 )edit