1. Ihad lotus 123 file that I saved in .xls 97-2003 format, some formulas was not converted by thesystem and correction and adjustment to excel must be done2. Inthe attached excel file there are 5 sheets , in the order as they appear in thelotus workbook, In the lotus version, as in the excel there is thesheet called “ universal macro”, in that sheet you can find two things , in thetope it’s the macro for the button in the “splash sheet” that able the user tochoose the languish. Down in the same sheet G36 , you find thetranslation of each line that need to be translated with thespecification of the location and the translation of each line in theworkbook (see attached file)my problem , if you look on thesheet called “Client Load Inf” & sheet “Analysis Report” you see thatI place of a text there is a Vlookup formula that refer to the sheet“universal macro” , first I would like to know what is the equivalent formulain excel to that Vlookup (lotus formula ) ? secondly how we create the same VBAmacro that give the option to choose the languish in the opening page, andthird can it be done in excel in more simply way , moreover how I make themacro for the button as they appear in the button sheet so the text on thebutton will be change according to the languish choice ????????? I am working with excel 2010 , butmost of my guys are saved in excel 97-2003 format , because my not all myclient have the 2010 yet