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
Hello,

Can anyone find any errors with this formula. I know it will never return a "N" because the vlookup will terminate anything that doesn't match the lookup value. A value in the array B2:B50000 should match should match up with the lookup value of D3.

I've tried
-formatting troubleshooting
-breaking down the function (issue lies within the VLOOKUP call option)



=IF(D3=VLOOKUP(D3,'folder/[filename.xlsx]Sheet1'!$B$2:$D$50000,1,FALSE),"Y","N")


2 replies

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
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.
0
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
Hi dear,
here index and match function should be used instead of vlookup.
0