To Find the type by looking up name

[michael35]

Hi. I have a column F. When a name is typed in Column G, the value from the table should be indicated in column F. For example if Jim is typed in G1, in F1 1 should be indicated.

[samba_ravi]

try the below and copy towards down
=IFERROR(INDEX(A:A,MATCH(G2,C:C,0)),"")

[michael35]

Thank you!!