Specific result from Vlookup

[robinmech]

Hi,

I,m trying to vlookup one cell value with the other. And I got the result also. But I want only one particular result if the cell values are matching. Rest results I want to keep blank even if its matching.

For example I have a list of drawing no's in first sheet and second sheet have the same drawing no's with the status. For eg: approved, Rejected, commented etc. So If drawing no's are matching then I need the only "approved" result in first sheet rest all matching results should be left blank.

Please help.

Thanks in advance

 

[Aladin Akyurek]

=IFERROR(IF(VLOOKUP(drawingnum,table,N,0)="approved","approved",""),"")

 

[robinmech]

=IFERROR(IF(VLOOKUP(drawingnum,table,N,0)="approved","approved",""),"")

Hi Aladin,

Thanks for your reply.
But I'm getting the result as blank.

 

[Aladin Akyurek]

Hi Aladin,

Thanks for your reply.
But I'm getting the result as blank.

Care to post the formula as you have implemented it?

 

[robinmech]

Care to post the formula as you have implemented it?

Hi'

I used the formula like this

=IFERROR(IDF(VLOOKUP(A2,REG,7,0)="APPROVED","APPROVED",""),"")

and the result is blank in all the cells

 

[robinmech]

Hi'

I used the formula like this

=IFERROR(IF(VLOOKUP(A2,REG,7,0)="APPROVED","APPROVED",""),"")

and the result is blank in all the cells

IF not IDF

 

[Aladin Akyurek]

IF not IDF

What does VLOOKUP(A2,REG,7,0) deliver/return?

 

[robinmech]

What does VLOOKUP(A2,REG,7,0) deliver/return?

It's giving me all the values in column 7 if criteria matches.

For Eg: Approved, RWC, Not Approved etc. I want to ignore all other results except "Approved"

 

[Aladin Akyurek]

It's giving me all the values in column 7 if criteria matches.

For Eg: Approved, RWC, Not Approved etc. I want to ignore all other results except "Approved"

When "approved" is returned by the VLOOKUP bit, the IF bit also returns "approved"; for any other result invluding #N/A, we get blank.

Does this return "approved" when VLOOKUP does so?

=IFERROR(IF(TRIM(VLOOKUP(A2,REG,7,0))="APPROVED","APPROVED",""),"")

 

[robinmech]

When "approved" is returned by the VLOOKUP bit, the IF bit also returns "approved"; for any other result invluding #N/A, we get blank.

Does this return "approved" when VLOOKUP does so?

=IFERROR(IF(TRIM(VLOOKUP(A2,REG,7,0))="APPROVED","APPROVED",""),"")

Now it's working perfectly. Thank you