Any formula?

[Saajith303]

 

above mentioned 1 image bill it's contain some datas but I want separate mobile numbers using reference code  which formula I can use

[#2]

Hi @Saajith303 

assuming that the reference number on your invoice is in cell E13 and the list with your mobile numbers is in sheet "Sheet1" in the range A2:E25 (like in your screenshot), you could use the following VLOOKUP-function:

=VLOOKUP(E13,Sheet1!A2:E25,4,false)