Nested If statement...
Closed
Andy
-
Aug 13, 2015 at 01:10 PM
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Aug 14, 2015 at 02:56 AM
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Aug 14, 2015 at 02:56 AM
Related:
- Nested If statement...
- How many if statements can you nest - Guide
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- Sbi bank statement - Guide
- Excel if statement contains multiple words ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 13, 2015 at 05:16 PM
Aug 13, 2015 at 05:16 PM
Andy, Good afternoon.
a) May be about column that you spoted.
VLOOKUP(D3,'folder/[filename.xlsx]Sheet1'!$B$2:$D$50000,1,FALSE)
Is this column do you really want???
b) May be a path to file:
VLOOKUP(D3,'folder/filename.xlsx]Sheet1'!$B$2:$D$50000,1,FALSE)
...'C:\Tasks\[File Name]Sheet1'!.........
I hope it helps.
a) May be about column that you spoted.
VLOOKUP(D3,'folder/[filename.xlsx]Sheet1'!$B$2:$D$50000,1,FALSE)
Is this column do you really want???
b) May be a path to file:
VLOOKUP(D3,'folder/filename.xlsx]Sheet1'!$B$2:$D$50000,1,FALSE)
...'C:\Tasks\[File Name]Sheet1'!.........
I hope it helps.
M.Hanzla
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
Aug 14, 2015 at 02:56 AM
Aug 14, 2015 at 02:56 AM
Hi dear,
here index and match function should be used instead of vlookup.
here index and match function should be used instead of vlookup.
