I need some help in converting EXCEL Vlookups, If, etc... functions to
convert them into Update and Insert Queries
in the Mysql Table.
I need someone who has experience in Advance Excel and mysql. The winner bidder i will send him the excel and more specified requirements
I have a Big Excel Table for example (A1 to D1) that I update from a txt file (Import), now Colums E1 till Z1 for example contain functions that
are vlookups, if, INdex, match , etc..
and this excel sheet I want to transform it mysql so that It doesn't take me alot of time copying and pasting, refreshing formulas, etc....
so the functions that I want to transform to mySQL are:
I need to update/ insert fields in the same table
Below is some of the excel function in the cell:
Mapping_TAB is a sheet that contain small tables that I lookup these values from, so from my side I will import them to separate tables.
the winning bidder i will forward the excel sheet and the requirents