Need Help with Vlookup

[liisocks]

Hello,

I am trying to use the Vlookup Function to pull the TGC code to give the right value in the Description cells. The TGC code is taken from Model sheet, column product number and the description cell should show the corresponding value in the model column of the Model sheet. Even though Ive put everything ascending and tried the range false, the value is isn't correct... what should I do?

Thank you,
liisock

[Jonmo1]

You probably need to use FALSE (or 0) as the 4th argument in your vlookup

=VLOOKUP($B$32,PRODUCTS,3,FALSE)

[oeldere]

d32=VLookup($B$32,PRODUCTS,3,0)

This gives the result N/A, since the productcode is not in the table.

You can prefent that by working with data-validation.

[FDibbins]

you left off the last part....

=VLOOKUP($B$32,PRODUCTS,3,0)
and that number doesnt exist in your list, so it will return an error

[Pete_UK]

You have defined your PRODUCTS as being columns A to L in the Model sheet, but the codes that you are using for your VLOOKUP are in column B of that sheet. So, using Name Manager, change the range for that name in the Refers to box to:

=Model!$B$1:$L$311

You will also need to change the formula in D32 of the Blizzard sheet to this:

=VLOOKUP($B32,PRODUCTS,2,0)

and this will allow you to copy it down if you have other codes.

Hope this helps.

Pete

[liisocks]

I made the changes and yes, I've typed the wrong product code but even if I put the right one 4211B101 and I add the zero...nothing changes. I still get the same error

[Pete_UK]

You probably started replying before I posted mine - see the comments relating to your named range.

Pete