Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pocket Excel

Status
Not open for further replies.

drans33

Technical User
Feb 25, 2003
1
GB
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top