SpreadsheetWeb
  • Features
  • Pricing
  • Blog
  • Customers
  • Try For Free
  • Sign In
    • Legacy Platform
    • SpreadsheetWeb Hub
Select Page
How to get Excel cell address of a lookup result

How to get Excel cell address of a lookup result

by Ilker | Jul 4, 2018 | Excel Tips & Tricks

This article shows you how to get Excel cell address of a lookup result by using the CELL and INDEX functions. Syntax =CELL( “address”, INDEX( data, MATCH( lookup value for row, lookup range for row, 0 ), column index ) ) Steps Start with the =CELL(...
How to get the worksheet name, workbook name, and its path

How to get the worksheet name, workbook name, and its path

by Ilker | Apr 6, 2018 | Excel Tips & Tricks

Working across several workbooks with multiple sheets can be tedious. Furthermore, file names are dynamic and can be changed by your users. Use this simple trick to organize your data and label workbook details. Syntax =CELL(“filename”, reference which is...
Page 1 of 11

Recent Posts

  • 5 Ways to Empower Businesses Operations with No Code
  • How to Increase Sales Teams’ Efficiency with SpreadsheetWeb?
  • How to Empower Marketing Teams with SpreadsheetWeb?
  • What’s New in SpreadsheetWeb Hub?
  • 3 Ways to Utilize Monday.com with SpreadsheetWeb

Product

  • Features
  • Demos
  • Customers
  • Developers & API

Solutions

  • Marketing
  • Human Resources
  • Finance
  • Sales

Use Cases

  • Online Calculators
  • Sales Quoting
  • Timesheet Apps
  • Scored Questionnaires

Support

  • User Guide
  • FAQ
  • Training Videos
  • Case Studies
  • Tips

Resources

  • Blog
  • Excel Applications
  • Excel Tips & Tricks
  • Excel Formulas
  • Excel Macros
  • Excel Templates

About

  • About Us
  • Contact Us
  • Services
  • Facebook
  • Twitter

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use