Exceeded IF nesting, what do i do?

Hi everyone, i have stumbled upon a problem while working in my spreadsheet.
I am what i would call an experienced novice in excel mostly using IF/OR/AND functions while i work. But this time my IF nesting has come to an end since Excel will only accept 64 nested IF statements.
I will try to describe what i want to achieve as simple as possible.

I have a table that looks something like this:

Partname:--------Partcode:

AA123-------------10
AB123-------------11
AC123-------------12
AD123-------------13
and continues with up to 100 partnames and their codes

What i want to achieve is in a new table (ex. a shopping list) when i write the part name in one of the columns in the new table that excel displays the corresponding partcode in the next column just like a multiple IFs command would do: Ex shown under:

Shoppinglist:

Partname i want to buy:--------Partcode for the item i want to buy:
AA123---------------------------(Fetched from the database table)
AB123---------------------------(Fetched from the database table)
AF123---------------------------(Fetched from the database table)[/FORMULA]
etc..


Excel limits me my use of a massive IF string, is this possible to do easily?

Any help is appreciated

Welcome to the forum!

Have a look at either the VLOOKUP function or the INDEX MATCH combination:

http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlFunctions03.html

Hi, welcome to the forum

Time to learn a new, and very useful, excel function...VLOOKUP

Assuming your source data is on sheet1 A2:B100...
=VLOOKUP(A2,sheet1!$A!2:$B$100,2,0)

Looks like you could use VLOOKUP.

Let's you have the PartName/PartCode table on Sheet1 in A1:B10.

If you had partnames on Sheet2 down column A you could use this formula in column B to return the partcodes.

=VLOOKUP(A1, Sheet1!$A$1:$B$10, 2, 0)

Happy to help.

VLOOKUP (and it's twin HLOOKUP) is the basic method for doing what you want, and where you know which column to use.

INDEX/MATCH/MATCH is a bit more complex (not much), but is also much more versatile, if you know neither the row number nor column you want

Good stuff, INDEX/MATCH/MATCH is your next assignment lol