Hi, I'm supposed to modify one tiny chunk of codes from a long VBA Excel Macro. That tiny chunk is currently looking up one worksheet. I need it to look up another worksheet first if it exists, otherwise look at the current worksheet. Could someone suggest how to modify it? Thanks!

workbooks (wkbk_accoun1).sheet("account1").select

amount1= worksheetfunction.match("colA", rows ("5:5"),0)