Results 1 to 19 of 19

how to look up a single value in a table

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    41

    how to look up a single value in a table

    hi there,

    how can i look up a single value in table of values n then get a return of some sort either telling me it exists or telling me which cell location that value is in.

    126 126 111 215 215

    363 232 179 188 893
    117 243 643 534 334
    243 581 192 138 622


    this is a typical table with values and i want excell to be looking up 215 in this table and telling me the cell location.


    help please!

    thanks
    Last edited by abz; 06-09-2010 at 01:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1