hi, attached is a sample book, but on sheet 2, column B, i would like to display only if 'QUOTE' sheet displays 'MISC' on the cell.
so basically, if its shows 'MISC' (on QUOTE SHEET) , to display on the sheet2 to on all the columns A, B, C, D. else just stays blank.
could someone help me please.
what i have in the cell formula is this: =IF(QUOTE!A1>0,QUOTE!A1," ")
Bookmarks