greylurcher
New Member
- Joined
- Jun 12, 2015
- Messages
- 5
Hi
I need a wee bit of help with this one, my iferror and vlookup works fine:
=IFERROR(VLOOKUP(E12,Sheet1!A3:A93,1,FALSE),"No")
However, instead of returning the value from column 1 in the vlookup I want it to return "Yes", I tried:
=IF(IFERROR(VLOOKUP(E11,Sheet1!A2:A92,1,FALSE),"No"),"","Yes")
and
=IF(IFERROR(VLOOKUP(E11,Sheet1!A2:A92,1,FALSE),"No"),"No","Yes")
Greateful for any insights.
I need a wee bit of help with this one, my iferror and vlookup works fine:
=IFERROR(VLOOKUP(E12,Sheet1!A3:A93,1,FALSE),"No")
However, instead of returning the value from column 1 in the vlookup I want it to return "Yes", I tried:
=IF(IFERROR(VLOOKUP(E11,Sheet1!A2:A92,1,FALSE),"No"),"","Yes")
and
=IF(IFERROR(VLOOKUP(E11,Sheet1!A2:A92,1,FALSE),"No"),"No","Yes")
Greateful for any insights.