nested if statement w/ a vlookup

[dazzarello]

Hello -
I need some guidance in the build out of an IF(and statement with a vlookup.
I have a workbook where I am pulling in perf ratings based on unique employee id numbers from one tab to another, once I pull the rating it into the 2nd tab, I would like to apply the logic whereby if the referenced cell =2,apply"BTA", if=3, "TGA", if 1, "EXA" and if =4, "URI". Just when I think I got the script, I get a VALUE error. any guidance would be appreciated...

=IF(VLOOKUP(A9,'Data Dump'!A9:Z63,26,FALSE)=1,"EXA"),IF(=2,"BTA"), IF(=3,"TGA"),IF(=4,"URI","")

 

[Teeroy]

Welcome to the forum.

Since you are returning a number the choose function will make it easier for you.

=CHOOSE(VLOOKUP(A9,'Data Dump'!A9:Z63,26,FALSE),"EXA","BTA","TGA","URI")

If you get a #VALUE error with this it means that you didn't get an integer match between 1 & 4 in the VLOOKUP.

 

[Marcelo Branco]

Hi and welcome to Mr Excel Forum

Try (Excel 2007 or higher)

=IFERROR(CHOOSE(VLOOKUP(A9,'DATA DUMP'!A9:Z63,26,FALSE),"EXA","BTA","TGA","URI"),"")

M.

 

[BobUmlas]

=IFERROR(CHOOSE(VLOOKUP(A9,'Data Dump'!A9:Z63,26,FALSE),"EXA","BTA","TGA","URI"),"")

 

[dazzarello]

Many many thanks, I was not familiar with the choose function.. so I really don't need to translate the value in column 26 to the abbrev noted above, I can simply order them in chronological order and it works? WHO KNEW..
Many many thanks, it was making me mad

 

[Aladin Akyurek]

Many many thanks, I was not familiar with the choose function.. so I really don't need to translate the value in column 26 to the abbrev noted above, I can simply order them in chronological order and it works? WHO KNEW..
Many many thanks, it was making me mad

It can be also done with what you already know:

Either...

=VLOOKUP(VLOOKUP(A9,'Data Dump'!A9:Z63,26,FALSE),Table,2,FALSE),

where Table consists of numbers and symbols.

Or...

=VLOOKUP(VLOOKUP(A9,'Data Dump'!A9:Z63,26,FALSE),{1,"EXA";2,"BTA";3,"TGA";4,"URI"},2,FALSE)