awk: print column $# if $#==[value]

If you’re looking for a specific value:

awk '$2==1 {print $3}' file

If you’re looking for a string, you have to use quotes otherwise awk will assume it’s a variable name:

awk '$1 == "findtext" {print $3}' file