Hi,
im trying to do a vlookup and if there is a value then show "CH", i can get this to work until there is no result and i have tried IFNA, IFERROR etc but always get the incorrect result.
basically im trying to lookup a date, check if a 3rd column has a value and if so return "CH" otherwise carry on with the next if, the problem is i can only get this to work with a double if, which then stops the next if working if no date is found, or it will show CH even if there is no value in the 3rd column. below is the sort of thing i am looking for, but i need it to ignore if there is no date and no value in 3rd column, hope this makes sense.
im trying to do a vlookup and if there is a value then show "CH", i can get this to work until there is no result and i have tried IFNA, IFERROR etc but always get the incorrect result.
basically im trying to lookup a date, check if a 3rd column has a value and if so return "CH" otherwise carry on with the next if, the problem is i can only get this to work with a double if, which then stops the next if working if no date is found, or it will show CH even if there is no value in the 3rd column. below is the sort of thing i am looking for, but i need it to ignore if there is no date and no value in 3rd column, hope this makes sense.
Excel Formula:
=if(vlookup(A1,c1:f20,3,FALSE)="y","CH",if(.......