Lookup and reference - Excel - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Lookup and reference

Documents 1-19 of 19

Page: [1] Go to previous page (disabled)

Lookup and reference functions (reference)

=ADDRESS(row num, column num, [abs num], [a1], [sheet text])

AREAS function

CHOOSE function

=COLUMN(reference)

COLUMNS function

HLOOKUP function

HYPERLINK function

=INDEX(array,row num,column num)

INDIRECT function

LOOKUP function

=MATCH(lookup value, lookup array, [match type])

OFFSET function

=ROW(reference)

=ROWS(array)

RTD function

TRANSPOSE function

VLOOKUP function

Video: Performing a VLOOKUP in Excel 2007 (Brainstorm Inc.)

Documents 1-19 of 19

Page: [1] Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office for Mac
» Office Community

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide