How can I use more than 64 levels of nesting

[bemp87]

Can someone please help! I have the following data in two columns, 'Column A' and 'Column B' that goes down to Row '163' with Data. In 'Column A' are names of systems in my organization, in 'Column B' are the descriptions for each system, I am running into the issue of 'cannot have more than 64 levels of nesting'. they way it was working currently before I got past 64 levels of nesting is, no matter which row the 'System Name' is in Column A, the description to match it would follow: please see brief line of code below:

SystemCodes = Is a worksheet that stores all the systems and names in non-alphabetical order
Codes = is the worksheet where the below formula is put in starting in cell B2.

Code:
=IF(A2=SystemCodes!$A$2,SystemCodes!$B$2,IF(A2=SystemCodes!$A$3,SystemCodes!$B$3,.... and so on until 163

I cannot complete my project because of the 64 levels of nesting issue.. Can someone please help me find a work around, all the data I am trying to pull is Text and numerical which is sometimes in the same cell.

Thanks in advance
Thanks in advance!

 

[Michael M]

Have you tried a VLOOKUP formula instead ??
Something like

=VLOOKUP(A2,SystemCodes!$A$2:$B$164,2,0)

drag down as required

 

[bemp87]

Thank you so much, it's working perfectly! One quick follow-up question, for empty cells that contain no data it's giving an error of "#N/A", any idea on how to make the cell blank if returned with no value?

Have you tried a VLOOKUP formula instead ??
Something like

=VLOOKUP(A2,SystemCodes!$A$2:$B$164,2,0)

drag down as required

 

[Michael M]

yep, try using

=IF(ISERROR(VLOOKUP(A2,SystemCodes!$A$2:$B$164,2,0)),"",VLOOKUP(A2,SystemCodes!$A$2:$B$164,2,0))

 

[bemp87]

Awesome!! Thank you so much, this worked perfectly and I was able to complete my project!

yep, try using

=IF(ISERROR(VLOOKUP(A2,SystemCodes!$A$2:$B$164,2,0)),"",VLOOKUP(A2,SystemCodes!$A$2:$B$164,2,0))

 

[Michael M]

Glad to help....