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 Rhinorhino 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
Joined
Feb 25, 2003
Messages
1
Location
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