Any formula?

New Contributor

IMG_20220530_142806.jpg

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:

 

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