Simplify excel formula

  • Thread starter Thread starter Eintsein_mc2
  • Start date Start date
E

Eintsein_mc2

I was wondering if there is a way to simplify this formula? Thanks
=IF(B21="A",VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,4,FALSE),IF(B21="B",VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,5,FALSE),IF(B21="C",VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,6,FALSE),IF(B21="D",VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,7,FALSE),IF(B21="T",VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,8,FALSE),IF(B21="R",VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,9,FALSE),""))))))
 
Try...

=VLOOKUP(A21,'Codes
All'!$A$4:$Q$170,MATCH(B21,{"A","B","C","D","T","R"},0)+3,0)

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula 1
VLOOKUP error 2
Sorting 1
Problem with nested IF and OR formula? 4
Empty cell in vlookup 9
MAX / OFFSET formula question 3
Modifying a complex date formual to count months 4
=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B 9

Back
Top