Arde 01
asked on
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
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
=IFERROR(IF(VLOOKUP(A1,She et2!A:B,2, FALSE)=0," -",VLOOKUP (A1,Sheet2 !A:B,2,FAL SE)),"_Not Found")
if you are looking for A1 in sheet2 recovering 2nd column
See attachment arde_01.xlxs
Stephane
arde_01.xlsx
if you are looking for A1 in sheet2 recovering 2nd column
See attachment arde_01.xlxs
Stephane
arde_01.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome to Expert Exchange!
Please post your current formula, if possible please attach sample/dummy workbook.