Skip to content

Instantly share code, notes, and snippets.

@ezhov-da

ezhov-da/vba-Ссылка на книгу в впр.vba

Last active March 10, 2019 12:18
Show Gist options
  • Save ezhov-da/c97f873adbba183ee8e3bba3fabd98ff to your computer and use it in GitHub Desktop.
Save ezhov-da/c97f873adbba183ee8e3bba3fabd98ff to your computer and use it in GitHub Desktop.
Download ZIP
vba ссылка на книгу в впр.vba
Raw
vba-Ссылка на книгу в впр.vba
'https://ru.vingrad.com/VPR-s-dinamicheskoy-tablitsey-id50bdbfcc6ccc19ae4f01c545
'http://excel2.ru/articles/funkciya-dvssyl-v-ms-excel-dvssyl
=ВПР(A1;ДВССЫЛ($E$1);2;0)
Значение E1 = [test.xlsx]Лист1!$A:$B
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment