IF FORMULAS
Closed
Wedge
-
Jun 1, 2009 at 10:59 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 2, 2009 at 04:38 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 2, 2009 at 04:38 AM
Related:
- IF FORMULAS
- Spreadsheet formulas - Guide
- Little alchemy formulas - Guide
- Ms excel marksheet formulas pdf - Guide
- Excel formulas number to words - Guide
- Excel recalculate formulas - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 2, 2009 at 04:38 AM
Jun 2, 2009 at 04:38 AM
Hi
Use vlookup =vlookup(lookupvalueCellAddress, 'Page 1'!DatabaseAddress,2,false)
eg. if you enter the code in A1 in page 2, In B1 you can get the description by using =vlookup(A1, 'Page 1'!$A$1:$B$100,2,false)
Change the 'Page 1 and 100 in the above example to match your figures
Use vlookup =vlookup(lookupvalueCellAddress, 'Page 1'!DatabaseAddress,2,false)
eg. if you enter the code in A1 in page 2, In B1 you can get the description by using =vlookup(A1, 'Page 1'!$A$1:$B$100,2,false)
Change the 'Page 1 and 100 in the above example to match your figures