Formula for returning values if true or false

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet which has three columns headed code 1 code 2 code 3. If a cell in a code 1 has an X I want that column heading returned, if its not found in that column then go to next column find the X and return that column heading instead eg code 2, and so on

Does anyone know how this may be done ?
 
This formula checks only the first 100 rows, but can be adapted to d
the entire column by changing the ranges:

=IF(ISERROR(MATCH("X",A2:A100)), IF(ISERROR(MATCH("X",B2:B100))
IF(ISERROR(MATCH("X",C2:C100)), "NONE", C1), B1), A1)

Even better, I tested it BEFORE I posted it...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Returning a value if true or false 3
Copy headin 1
TRUE/FALSE STATEMENT 4
Using H/VLOOKUP to return multiple values 2
Formula to return a formula 1
Look up, return value 5
if statement to return a list of values where answer is true 8

Back
Top