Maybe

=VLOOKUP(G12,A1:C30,3,FALSE)

Mike

"RJJ" wrote:

How do I create a formula to have cell show the value in C2 or C3 or C4
etc...based on what is in A2 or A3 or A4 etc... EG: If (G12=A2 then C2)...or
if (G12=A3 then C3)...or if (G12=A4 then C4) and so on as many as 30 times.