0 down vote I am not good in writing full code till now and I need your help to create a code for browsing for any file and get this file path and using it in VLOOKUP formula which will be used in all non blank cells in the entire column of sheet 1. More info: Sheet2: A1:A5....(1,2,3,4,5) B1:B5....(A,B,C,D,E) Sheet1: A1: 1 A2: 2 A3: 3 A4: 4 A5: 5 B1= Vlookup(A1,"path of sheet2",$A$1:$B$5,2,False) B2= Vlookup(A2,"path of sheet2",$A$1:$B$5,2,False) B3= Vlookup(A3,"path of sheet2",$A$1:$B$5,2,False) B4= Vlookup(A4,"path of sheet2",$A$1:$B$5,2,False) B5= Vlookup(A5,"path of sheet2",$A$1:$B$5,2,False)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

browse for excel file and getting its path then Vlookup Code for entire column using this file path

Thread starter bebo201022
Start date Sep 24, 2017
Tags

$a$1$b$5 false file filepath & vlookup sheet2

bebo201022

New Member

Sep 24, 2017

0 down vote

I am not good in writing full code till now and I need your help to create a code for browsing for any file and get this file path and using it in <code>VLOOKUP</code> formula which will be used in all non blank cells in the entire column of sheet 1.
More info:
Sheet2:
<code>A1:A5....(1,2,3,4,5)
B1:B5....(A,B,C,D,E)
</code> Sheet1:
<code>A1: 1
A2: 2
A3: 3
A4: 4
A5: 5
B1= Vlookup(A1,"path of sheet2",$A$1:$B$5,2,False)
B2= Vlookup(A2,"path of sheet2",$A$1:$B$5,2,False)
B3= Vlookup(A3,"path of sheet2",$A$1:$B$5,2,False)
B4= Vlookup(A4,"path of sheet2",$A$1:$B$5,2,False)
B5= Vlookup(A5,"path of sheet2",$A$1:$B$5,2,False)
</code>

Last edited by a moderator: Sep 24, 2017