Dollar Sign not showing

Ramco Ramco

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Deepak Rawat3y ago
If you want to display both the numerical value and the dollar sign in the result of the VLOOKUP formula in Excel, you can achieve this by using the CONCATENATE function or the ampersand (&) operator to combine the dollar sign with the numerical value.
```
=CONCATENATE("$", VLOOKUP(28, A2:F214, 4, FALSE))
```
or
```
="$" & VLOOKUP(28, A2:F214, 4, FALSE)
```
Both formulas will return "$7,163" instead of just "7163" in the cell.

Make sure to adjust the cell references (A2:F214) and the lookup value (28) based on your actual data range.
Brahma Prakash Shukla3y ago
```
=VLOOKUP(28, A2:F214, 4, FALSE) & " " & TEXT(VLOOKUP(28, A2:F214, 4, FALSE), "$#,##0.00")
```
In this formula, we concatenate two parts: the result of the VLOOKUP function (VLOOKUP(28, A2:F214, 4, FALSE)) and the result of the TEXT function (TEXT(VLOOKUP(28, A2:F214, 4, FALSE), "$#,##0.00")).

The first part of the formula (VLOOKUP(28, A2:F214, 4, FALSE)) retrieves the numerical value from the lookup table.

The second part of the formula (TEXT(VLOOKUP(28, A2:F214, 4, FALSE), "$#,##0.00")) converts the numerical value into a formatted string with the dollar symbol and comma separators using the TEXT function.

By concatenating these two parts with the " " (space) in between, you can display both the numerical value and the currency symbol. The result will be something like "7163 $7,163.00" in the cell where you enter this formula.

Make sure to adjust the cell references and ranges (A2:F214) in the formula to match your actual data range.
Rajkiran Swain3y ago
Hi,

To display the dollar sign along with the numerical value in your VLOOKUP formula result, you can use the TEXT function to format the value as currency. Here's an example of how you can modify your formula:

=TEXT(VLOOKUP(28,A2:F214,4,FALSE),"$0.00")

This formula will return "$7,163" instead of just 7163. The TEXT function allows you to apply custom formatting to the value retrieved by the VLOOKUP function. By including "$0.00" as the format code, it ensures that the result is displayed as currency with the dollar sign.

Please try using this modified formula and let me know if it resolves the issue.