match and vlook up

[andy]

trying to do a price list update got a vlook up to work
but that only finds the that part number that i specife at
that cell how do i get it find a part number down the hole
range in col 1 this is the vlookup that work i think i
need a match as well but not sure how i add this to a
vlookup =VLOOKUP(10011,Sheet4!A3:Sheet4!D3,4)

any help been at this for 2 days now going mad

 

[Frank Kabel]

Hi
if your part number is in column A try
=VLOOKUP(A1,Sheet4!$A$3:$D$3,4)
and copy this down

 

[Guest]

thanks for that but i just get a ref error when i do this
any more thought would be of help thank you again

 

[Frank Kabel]

Hi
maybe something like
=VLOOKUP(A1,'Sheet4'!$A$31$D$300,4)
will do.

 

[Guest]

thanks for that the problem was that the first col in the
vlookup had some , or something at the front of it that
was hiden and shows up as the erorr i unprotected the book
and got rid of it and it work to a point but the a new
problem The col i am looking at are sorted the same but
not the same in that col 1 has one part no and the new
price list containes some new one this messes up the order
and then gives me a erorr ref is there a way to tell it to
find the right match even if there not sorted in the right
order ?
thank for the help i may have some hair left at this rate