Nested If statement...

[Closed]
Report
-
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
-
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

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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.
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
Hi dear,
here index and match function should be used instead of vlookup.