Need to change Vlookup formula!

Hi,

I need to change a formula. Basically I have 2 excel sheets. In the first I have a column in which is used Vlookup formula. And it is used to find out the assessment text ("Yes", "No"or "Blank" in a table which is in another excel sheet!) What i need to do is to change the vlookup formula in the first sheet in order to have "-" instead of blank cells. How can I do it?
Thank you in advance!

Best,
Edra
Arde 01Business InternAsked:
Who is Participating?
 
stefriCommented:
Hi Shums
Will work too but will not detect unknown looked values (imho)
Stephane
0
 
ShumsDistinguished Expert - 2017Commented:
Hi,

Welcome to Expert Exchange!

Please post your current formula, if possible please attach sample/dummy workbook.
0
 
stefriCommented:
=IFERROR(IF(VLOOKUP(A1,Sheet2!A:B,2,FALSE)=0,"-",VLOOKUP(A1,Sheet2!A:B,2,FALSE)),"_Not Found")
if you are looking for A1 in sheet2 recovering 2nd column
See attachment arde_01.xlxs
Stephane
arde_01.xlsx
0
 
ShumsDistinguished Expert - 2017Commented:
Hi Stephane,

Try below:
=IFERROR(IF(VLOOKUP(A1,Sheet2!A:B,2,FALSE)=0,"-",VLOOKUP(A1,Sheet2!A:B,2,FALSE)),"-")

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.