excel - VLOOKUP #N/A error -

i'm wondering have done wrong #n/a error

i have k21 show agent's name worked on ticket appeared in k20. have agent names listed in b3:b18.

columns have: c total, d type , e subtotal.

ticket numbers logged column f3, g, h , on each agent

k20 has =min(f3:xfd18) determine oldest ticket.

k21 has =vlookup($k$20,b2:g18,3,false) show agent's name logged oldest ticket.

i'm bit confused you're asking sounds might using formula wrong. if wanting return agent's name oldest ticket make sure columns in correct order (a-lookup value,b-agent name,c-other variable). using format can try k21=vlookup($k$20,a2:b18,2,false) ----where a2:a18 has value looking , 2 second column (b) , has agent's name.