R Lookup data “falsly” returns NA

Hi, it is very difficult to give you concrete steps to solve your problem without reproducible example. Please have a look at this guide, to see how to create one:

In general, what you doing is very likely doable and not very difficult.