What formula should I be using to populate one column’s data automatically based on my entry for another column?

Hi! I need some help here. first off, I’m not allowed to use a v-lookup for this file due to some organisational restrictions, so i’m unable to create a table 2 to facilitate the lookup values. I’m only allowed to use table 1 itself, which is where I have to put in all my values.

I have been trying to use index/match instead but can’t see to figure the right formula out.

so basically, what I need is for my manual input of data in column J to populate the associated remark in column K.

• column J input “NA” = column K input “visit 2”

• column J input “nil” = column K input “insufficient blood”

• column J input “1” = column K input blank

these are the only 3 that I require. let’s say I require it for 30 rows. so my range of rows to populate would be K2:K30 based on the directly adjacent data of J2:J30.

how can I do this in formula or automation? thanks in advance!