VBA to replace lengthy Nested IF statements

[Hootywho]

New project...

Can someone please point me in the right direction. I am working to simplify an existing spreadsheet that has multiple lengthy nested IF statements. The need to do so is based on the restriction of 64. I've tried VLOOKUP, etc and have found nothing that has worked well as of yet. The following is an example of what I am trying to do...

Column A - User enters an inventory code (001-500)
Column O - This is the list of inventory codes (001-500)
Column P - This is the item description associated with the inventory code in column O

Goal - Once user enters inventory code (001-500) in column A, I need column B to automatically populate with the description in column P (associated with it's code in column O).

Hope that all makes sense. I tried a search and could not find exactly what I was looking for on the web.

Many Thanks!

[Norie]

VLOOKUP should work, how did you try it and how did it not work?

Are the values in column 0 numeric or numbers stored as text?

[Hootywho]

The VLOOKUP was limited to 64, I have approximately 500 inventory items / codes. Unfortunately the inventory codes are specific and cannot be changed for this purpose. All codes are both letters and numbers. Example - CDM.02

[FDibbins]

Agree that it sounds like vlookup should work.

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Norie]

Limited to 64 what?

I would have though a simple VLOOKUP like this would be all you needed.

Please Login or Register  to view this content.

[Hootywho]

The portion I have been tasked with working is attached.

[Norie]

Put this in D8 and copy down.

Please Login or Register  to view this content.

[Hootywho]

Awesome, Thank you sir. Any way to not have the #N/A in the cells until you enter a value in the B column? Not a big deal, just curious.

[FDibbins]

maybe this...
=iferror(VLOOKUP(B8, $O$1:$Q$1000,3, 0),"")

[Hootywho]

Again, perfect. Thank You!

[Hootywho]

I'm not sure if it is my job to mark this as solved or not. I was unable to determine just how to do that if so. Thanks to the folks that assisted, I may be back as this project progresses. Thanks again!