Any formula?

New Contributor


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

1 Reply

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: