jocker_boy
Board Regular
- Joined
- Feb 5, 2015
- Messages
- 83
Hi,
I would like to add vlookup formula with VBA considering:
Thanks for the help.
Gonçalo
I would like to add vlookup formula with VBA considering:
- We are in "Sheet1"
- The Table Array will be in another sheet, based on the name in cell A2 (In this case "Sheet5")
- It will start in A1
- The D10 is the last row and last column in "sheet5"
Sheet5 | |
A | =vlookup(A;'sheet5'!A1:D10;2;FALSE) |
B | =vlookup(B;'sheet5'!A1:D10;2;FALSE) |
C | =vlookup(C;'sheet5'!A1:D10;2;FALSE) |
Thanks for the help.
Gonçalo