| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and adding text
How would I write the vlookup formula where, if vlookup formula returns a
number, then I want the number to include "/ month" after it. If the vlookup does not return a value, then I want to show a blank. For example, my vlookup formula is vlookup(B2,database,3,false) returns 4,031. I want the cell to read "4,031 / month" . any help is much appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup and adding text
Try this:
=IF(ISNUMBER(MATCH(B2,INDEX(database,,1),0)), VLOOKUP(B2,database,3,0)&" / month","") Biff "Confused" wrote in message ... How would I write the vlookup formula where, if vlookup formula returns a number, then I want the number to include "/ month" after it. If the vlookup does not return a value, then I want to show a blank. For example, my vlookup formula is vlookup(B2,database,3,false) returns 4,031. I want the cell to read "4,031 / month" . any help is much appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup and adding text
the formula works great. But just one more thing, the value that is return
is 4031 / month. how do I get it to show $4,031 / month? Thanks "Confused" wrote: How would I write the vlookup formula where, if vlookup formula returns a number, then I want the number to include "/ month" after it. If the vlookup does not return a value, then I want to show a blank. For example, my vlookup formula is vlookup(B2,database,3,false) returns 4,031. I want the cell to read "4,031 / month" . any help is much appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup and adding text
Try this:
=IF(ISNUMBER(MATCH(B2,INDEX(database,,1),0)), TEXT(VLOOKUP(B2,database,3,0),"$#,###")&" / month","") Biff "Confused" wrote in message ... the formula works great. But just one more thing, the value that is return is 4031 / month. how do I get it to show $4,031 / month? Thanks "Confused" wrote: How would I write the vlookup formula where, if vlookup formula returns a number, then I want the number to include "/ month" after it. If the vlookup does not return a value, then I want to show a blank. For example, my vlookup formula is vlookup(B2,database,3,false) returns 4,031. I want the cell to read "4,031 / month" . any help is much appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding text to a vlookup cell | New Users to Excel | |||
| Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
| Adding VLOOKUP | Excel Worksheet Functions | |||
| Adding two columns with vlookup | Excel Worksheet Functions | |||
| Adding using Vlookup | Excel Discussion (Misc queries) | |||
Hybrid Mode
