Results 1 to 3 of 3

formula to look for cells with values and output result to different column

Threaded View

  1. #1
    Forum Contributor Red fuji's Avatar
    Join Date
    03-21-2012
    Location
    The earthquake state, USA
    MS-Off Ver
    2016 Office
    Posts
    140

    formula to look for cells with values and output result to different column

    I need help with a formula that would look for cells in column 'A' that contain a value. Then it would read the corresponding status in column 'B' and copy the value in that cell to a different sheet. If the cell contains a value but the corresponding status cell is blank then the result would be "NA". Cells containing no values can be ignored.

    Thanks for your time and effort.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1