Is it possibly to look at cell value and if in a range to place the record #
in a cell ?

E.g.
Value in A2 that I need to know if in a range "R1234JK-3"

RANGE
Record # Proj # Billing # Review #
1 R1234JK-3 KIKII-87 KL12367
2 RM334 12456 0089JK_9

Ce;; Value returned in A3 "1" which stands for record 1