Double IF statement and Vlookup

[ldashev]

Need some help with a formula and I'm going to try to formulate what I'm trying to achieve and write down the logic below in steps:
1) Take value in TABLE 1 and Lookup for matching value in TABLE 2
2) If value is found then go 5 fields across (to the right) and bring back the value (value are either "blank", "Yes" or "No")
3) When value is blank record in the field as " ", when value is "No" record it as "N", when value is "Yes" go 2 cells over and bring back the value in the cell.

so far I have the formula covering steps 1 and 2, but struggling to get step 3, here's the formula below:

=IF(ISBLANK(VLOOKUP(D2,'QA Sheet'!$A$2:$AM$339,5,FALSE))," ",VLOOKUP(D2,'QA Sheet'!$A$2:$AM$339,5,FALSE))

TABLE 1 - is where the output goes
TABLE 2 - contains all of the data

 

[Eric W]

If I'm recreating your spreadsheet properly, then this should work:

	A	B	C	D	E	F	G	H	I
1									N
2	1			3			A
3	2				Yes		B
4	3				No		C
5	4				Yes		D
6	5						E
7	6				No		F
8	7				Yes		G
9	8				No		H
10

<tbody>
</tbody>

QA Sheet​

Worksheet Formulas Cell Formula I1 =IFERROR(CHOOSE(MATCH(VLOOKUP(D2,'QA Sheet'!$A$2:$AM$339,5,FALSE),{" ","No","Yes"},0)," ","N",VLOOKUP(D2,'QA Sheet'!$A$2:$AM$339,7,FALSE)),"") <tbody> </tbody>

<tbody>
</tbody>

 

[ldashev]

Thank you! That worked to perfection

 

[Eric W]

Glad to help!