i am new to excel and i am trying to update a stock sheet

**Tony Valko** · 12-09-2014, 09:38 PM

I didn't download your file.

=IFERROR(VLOOKUP(A2,$B$2:$B$9999,2,0),"(NO MATCH)")

Your lookup table consists of a single column. Maybe this...

=IFERROR(VLOOKUP(A2,$B$2:$C$9999,2,0),"(NO MATCH)")

**trinimoses** · 12-09-2014, 11:28 PM

i got it to work.. seems a it was a region issue.. my excel i cant use " , " .. i have to use " ;" ..

so it ended up being :
=IFERROR(VLOOKUP(A2;$B$2:$C$329;2;0);"0")

thanks for the feed back.

**Tony Valko** · 12-09-2014, 11:45 PM

Good deal. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.