Mulitple if statements and vlookups

[tcrjmom]

Hello,
I'm attempting to write an IF statement with vlookups (I've tried the formula as a Nested, but continue to get an error). I've attempted to place an ISNA within the formula but, can't figure out how to get to the second vlookup.

=IF(A3=1,"",IF(C6>2,IF(A3=2,VLOOKUP(D11,ACG3:ACI4500,2,FALSE),if(A3=3,VLOOKUP(D11,ACJ3:ACK4500,2,FALSE))))

In words:

If Cell A3 (Country) equals 1 (1 = "select a county"), then I want the formula to stop
If Cell C6 is greater than 2 (1 = Select Text or part Number, 2 = Search by Text and 3 = Search by Part Number) and Cell A3 equals 2 (2 = CAD item)
then I want you to lookup the part number entered in Cell D11 from Columns ACG3:ACI4500 (CAD pricebook)
and return the Description of the part number (column 2);
HOWEVER ,
If Cell A3 equals 3 (3 = USD item) then I want you to lookup the part number entered in Cell D11 from Columns ACJ3:ACK4500 (USD pricebook)
and return the Description of the part number (column 2)

The formula keeps getting stuck on the 1st VLOOKUP becuase it returns an N/A#

Please help.

[NBVC]

So you are saying that C6 is greater than 2 and A3 is equal to 2, so your first VLOOKUP should return a result? If so, then make sure the value in D11 exactly matches the value in column ACG

[tcrjmom]

ACG & ACJ are lists of part numbers - D11 is one part number that I needed to look up. If the order is CAD I need the part number to be looked up in the CAD Parts List (ACG) if the order is USD I need the part to be looked up on the USD Parts list (ACJ). Cell A3 determins if the order is CAD or USD.

[NBVC]

Are the parts actually numeric? IF so, are the columns of numbers formatted like D11?

[tcrjmom]

Format of part number = abc-def-ghi (alpha)

[NBVC]

The other thing to check then, is look for extra spaces at the end of the matching strings...

If still a no-go, post a sample workbook.