Hi
I have below data . When i use Vlookup it shows only numerical value . I want Dollar should also be shown. It shows only 7163.
=VLOOKUP(28,A2:F214,4,FALSE)
27 Mango Fruit $7,388 18/02/2016 France 28 Beans Vegetables $7,163 18/02/2016 United States
Thanks