Hello - I am new to the board and wondering if somebody could help me find the correct syntax. I am using Win 7 and Excel 2010. I have the following formula, =IF(ISNA(MATCH(B2,'Res Gps'!A:A,0)),"No","Yes"), that takes a look at cell B2, then goes to another worksheet 'Res Gps' in the same workbook to see if it finds a match in the A column. If it finds a match, it returns a Yes value, if not, it returns a No value.
I need this formula to look in column C first and determine if that particular column is empty, that's why I was trying to use the ISBLANK function. If column C is populated, I need it to be able to make the match from the 'Res Gps' worksheet from the C column. If column C is empty, I need it to be able to make the match from the 'Res Gps' worksheet from the B column.
Sorry for rambling on, hope this makes sense. Thanks for any help offered.
I need this formula to look in column C first and determine if that particular column is empty, that's why I was trying to use the ISBLANK function. If column C is populated, I need it to be able to make the match from the 'Res Gps' worksheet from the C column. If column C is empty, I need it to be able to make the match from the 'Res Gps' worksheet from the B column.
Sorry for rambling on, hope this makes sense. Thanks for any help offered.