excel formula

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

Eintsein_mc2

Hi, I'm wondering if this formula could simplified? 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),""))))))
 
=VLOOKUP(A21,'Codes All'!$A$4:$Q$170,CODE(B21)-65,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Simplify 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