Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help - Vlookup reference nightmare

Status
Not open for further replies.
01491

01491

ISP
Oct 30, 2001
17
0
0
GB
I'm trying to write a For..Next loop for a vlookup in Excel.
For each loop, I want the reference area to move down a row.

ie.

vlookup(A1,Sheet1!A1:D1,3,False)

then next loop

vlookup(A1,Sheet1!A2:D2,3,false)

Declaring a variable V for the reference area - just doesn't work.

Any ideas?
Thanks
JAP
 
Status
Not open for further replies.

Similar threads

tomminil4
  • Locked
  • Question
Help with VBA code
Replies
3
Views
118
strongm
strongm
f0rg3tfu1
  • Locked
  • Question
circular reference caused by alias in query definition
Replies
7
Views
141
strongm
strongm
R_a_i_n_e_r_8
  • Locked
  • Question
Compile error: Types of intolerance (need help)
Replies
3
Views
209
strongm
strongm
sal21
  • Locked
  • Question
please strongm, big help
Replies
6
Views
91
sal21
sal21
sal21
  • Locked
  • Question
big help on rest api 2
Replies
17
Views
143
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top