Tag Info

Hot answers tagged

4

Please try something like: =vlookup(A1,Sheet2!H:I,2,0) where ColumnH in Sheet2 ('other sheet') contains Number and ColumnI of the same row the corresponding unit price.


1

Yes, it's possible, select the mask (not the image), grab the little dot on a stalk and drag it round half a circle:



Only top voted, non community-wiki answers of a minimum length are eligible