Jaimetimbrell,

Although you do not specify what you mean they do not work, I suspect
you are getting an error because LOOKUP expects an actual range
reference and not a computed array, as you are supplying.

Try the combination INDEX($A$2:$A$6000, MATCH(G2,
IF($C$2:$C$6000=ROWS($A$2:$A2),$B$2:$B$6000)))

Does this help?
Kostis Vezerides