View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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