Add a text word into an IFERROR_vlookup function

[Gtasios4]

Hi All,

I have in the below tool the unit price of a product which is extracted by the following function from another sheet in the workbook.

=IFERROR(IF(VLOOKUP(A4;'SΕRVERS & OPTIONS'!B:E;4;0)="-";VLOOKUP(A4;'SΕRVERS & OPTIONS'!B:D;3;0);VLOOKUP(A4;'SΕRVERS & OPTIONS'!B:E;4;0))*(1-($S$2-1)%);)

So in the sheet where the VLOOKUP is performed it either finds the normal price or the Promo price. I want to add in the above function the text "Promo price at:" coupled with the promo price when it founds it.

Any hint would be appreciated.

 

[Fluff]

Which vlookup returns the promo price?

 

[Gtasios4]

Which vlookup returns the promo price?

This one VLOOKUP(A4;'SΕRVERS & OPTIONS'!B:E;4;0)

 

[Fluff]

Ok, how about

=LET(m,MATCH(A4,'SΕRVERS & OPTIONS'!B$2:B$1000,0),p,INDEX('SΕRVERS & OPTIONS'!E:E,m),IF(ISNA(m),0,IF(p="-",INDEX('SΕRVERS & OPTIONS'!D:D,m),"Promo price at:"&p*(1-($S$2-1)%))))