CONCATENATE with IF VLOOKUP

[Busymanjohn]

Hi, I have a simple IF VLOOKUP formula within which I am looking to incorporate CONCATENATE .... The IF VLOOKUP works fine, but would like to be able to place "k" after the end result ,,,, e.g. cell column A contains a list of products, column B targets, column C contains ships. In E2 I have the IF VLOOKUP which is IF(VLOOKUP(D2,A1:C30,2,0)-VLOOKUP(D2,A1:C30,3,0)<0,0)) ... the result of which I want the letter k afterwards, to represent thousands.

 

[Luke M]

You can do this via formula:

=IF(blah blah blah)&" k"


or you could do a custom number format of:

0" k"


The latter might be preferrer as the value of the cell would still be a number and you could do mathematical operations on it. Or perhaps, if you actually want the thousands value, use a formula of:

=IF(....)*1000


with a custom number format of:

0," k"

 

[Busymanjohn]

Hi Luke ,,,, thanks, just what i needed. Thanks again.