Forum Discussion
Any formula?
above mentioned 1 image bill it's contain some datas but I want separate mobile numbers using reference code which formula I can use
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)