how do i do an advanced look up

[dannyi21i]

i thought had the right formula however the formula i have used in the pic only shows numbers as i didnt count for if a game gets postponed, if a game gets postponed it shows a 'p' instead of a number which messes up the formula.

The formula needs to try and find the team name from column 'c' and show the cell out of column 'j' which it lines up with.
if the teams not in column 'c' the look up needs to find the team in column 'g' and show the cell in column 'k' it lines up in.

(sorry if my explaination of this is bad, i didnt know how to explain it)

<a href="http://tinypic.com?ref=35atdsi" target="_blank"><img src="http://i65.tinypic.com/35atdsi.jpg" border="0" alt="Image and video hosting by TinyPic"></a>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1045370-how-look-up-through-2-list.html#post5019151

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.