dazzarello
New Member
- Joined
- Jan 13, 2014
- Messages
- 2
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","")
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","")