Does anybody know how to lookup a number of
different cells in another table or sheet, example
Table 1
Confectionery
A row(PRODUCT No) B row Description
330001 Mars Bar Std
330002 Twix Large
330003 Kit Kat 4 Finger
330004 Jelly Babies
Table 2
A row B row
(Insert product No ie 330003) (Return automatically Desc)
I have tried the VLOOKUP, but I do not know the correct
formula.
Kind regards
different cells in another table or sheet, example
Table 1
Confectionery
A row(PRODUCT No) B row Description
330001 Mars Bar Std
330002 Twix Large
330003 Kit Kat 4 Finger
330004 Jelly Babies
Table 2
A row B row
(Insert product No ie 330003) (Return automatically Desc)
I have tried the VLOOKUP, but I do not know the correct
formula.
Kind regards