VLookup For Same Value but in 2 Different Columns

[USFengBULLS]

Hello All,

I have a column of cell on one sheet that I am having lookup the description in the table in another sheet based off the status.
Basically the formula works for this =VLOOKUP(B11,'FINISH LIST'!B11:J495,6,FALSE) and its is returning the status fine, but I also need it to look into column 9 for the status there.
there are two columns on that sheet, Columns 6 & 9, that are labeled status and I need the v lookup to check both and return the status. there will never be a case where there will be a status in both column 6 and 9. I know this is wrong but it need to do this in simple form =VLOOKUP(B11,'FINISH LIST'!B11:J495,OR(6,9),FALSE). Something like that.

 

[Aladin Akyurek]

How does a status value look like?

 

[USFengBULLS]

Either Approved or Rejected from a drop down list...if that was what your meaning. Both strings or text

 

[GR00007]

Would something like this work:
=IFERROR(VLOOKUP(B11,'FINISH LIST'!B:G,6,FALSE),VLOOKUP(B11,'FINISH LIST'!B:J,9,FALSE))

 

[Aladin Akyurek]

Either Approved or Rejected from a drop down list...if that was what your meaning. Both strings or text

Try...

=LOOKUP(REPT("z",255),VLOOKUP(B11,'FINISH LIST'!B11:J495,{6,9},0))