Vlook up to return text unless the cell contains a certain phrase in which case I want it to look and return another cell?

[Noswen869]

Hello!

I'm hoping there is a formula which allows me to effectively use a vlookup to return whatever text is in a certain cell BUT if that cell contains the phrase "skip" or "skip 2" I want the vlookup to look at a different cell instead (unless that too contains "skip"/"skip 2" etc)

Is this possible? Any help would be much appreciated

 

[Kaper]

Without this last phrase "(unless that too contains "skip"/"skip 2" etc)" it could be done with IF function, like =IF(originalvlookup<>"skip";originalvlookup;taking_care_of_skip_situation)
But if that can be recursive (next one could be skip 2 and than skip and next skip 3)... probaly VBA (possibly UDF written in VBA) shall be used.

If allow VBA use, sample data layout and expected results would make programming much easier.