VLOOKUP error
Hi I keep getting an error when I try and put in the last vlookup into
the formula.
=IF(B21="RG",VLOOKUP(A21,'Codes
All'!$A$4:$Q$80,4,FALSE),IF(B21="RC",VLOOKUP(A21,' Codes
All'!$A$4:$Q$80,5,FALSE),IF(B21="TG",VLOOKUP(A21,' Codes
All'!$A$4:$Q$80,8,FALSE),IF(B21="TC",VLOOKUP(A21,' Codes
All'!$A$4:$Q$80,9,FALSE),IF(B21="BG",VLOOKUP(A21,' Codes
All'!$A$4:$Q$80,12,FALSE),IF(B21="BC",VLOOKUP(A21, 'Codes
All'!$A$4:$Q$80,13,FALSE),IF(B21="AG",VLOOKUP(A21, 'Codes
All'!$A$4:$Q$80,16,FALSE),IF(B21="AC",VLOOKUP(A21, 'Codes
All'!$A$4:$Q$80,17,FALSE),"")))))
I think that this formula could be condenced if I only new how to do
it. If any one can help it would be great.
|