ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   russian excel vlookup (https://www.excelbanter.com/excel-worksheet-functions/79475-russian-excel-vlookup.html)

S.O'Reilly

russian excel vlookup
 

Hi - I am trying to teach a colleague over the phone how to use the
vlookup function but he can't find it in the Russian version of excel
he's using - any one know what vlookup is called in russian language
excel? thanks if you can help!


--
S.O'Reilly
------------------------------------------------------------------------
S.O'Reilly's Profile: http://www.excelforum.com/member.php...o&userid=32791
View this thread: http://www.excelforum.com/showthread...hreadid=526141


Dave Peterson

russian excel vlookup
 
Maybe you can cheat a bit.

Have him start a new worksheet or workbook (just to be safe)

Have him hit alt-f11 to get to the VBE (where macros live)
then hit ctrl-g to see the immediate window.


Have him type this and hit enter

range("a1").formula = "=vlookup(b1,c:d,2,false)"

And hit enter.

Then back to excel and have him read you the formula in A1 of the activesheet.


======

Maybe this will help with other formulas:

KeepItCool has a translator utility at:
http://members.chello.nl/keepitcool/download.html

"S.O'Reilly" wrote:

Hi - I am trying to teach a colleague over the phone how to use the
vlookup function but he can't find it in the Russian version of excel
he's using - any one know what vlookup is called in russian language
excel? thanks if you can help!

--
S.O'Reilly
------------------------------------------------------------------------
S.O'Reilly's Profile: http://www.excelforum.com/member.php...o&userid=32791
View this thread: http://www.excelforum.com/showthread...hreadid=526141


--

Dave Peterson


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com