Results 1 to 2 of 2

Searching multiple columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    809

    Searching multiple columns

    A spreadsheet has multiple 'paired' columns. Column "A" has part numbers with the supplier in column "B", column "C" has more (different) part numbers with the supplier in column "D", column "E" has more (different) part numbers with the supplier in column "F", etc. etc.

    How would I find the supplier for a part number which could be (only once) in any of the coulmns apart from using IF NA# or IF Error?
    Last edited by BRISBANEBOB; 12-29-2008 at 07:28 PM.

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