vlookup is what I think I need but its doing my head in

  • Thread starter Thread starter Stewit
  • Start date Start date
S

Stewit

hi please help as this is really doing my head in I have tried to apply the
method from the sample invoice example given on
http://www.mvps.org/dmcritchie/excel/vlookup.htm#match and so far im going
nowhere fast!!

This is the formula im using to reduce stock on my "stock" sheet as I enter
the code in the March 04 sheet that works perfectly :)
=COUNTIF('March 04'!$F$3:$F$100,"1")

I enter the stock code in COL F on my "March 04" I have the same codes and
my descriptions in another sheet called "stock" in the same workbook, im
trying to get the description in COL B of the "stock" sheet to copy to COL G
in my "march 04" sheet.

thanks in advance

Stewart
 
Hi
not quite sure I understood you correctly but try
=VLOOKUP(F1,'stock'!$A$1:$B$1000,2,0)
 
Frank!!!

Thank you so very much, that was perfect :) :) :) you can label me the
happiest Kiwi in NZ right this minute.....

lol my wife is looking at me in a very strange manner, must be the happy
dance i was doing :)

thanks again :):):)
 
Back
Top