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
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)
