Results 1 to 4 of 4

can lookup a number to a 10x10 table?

Threaded View

  1. #1
    Registered User
    Join Date
    05-10-2005
    Posts
    16

    can lookup a number to a 10x10 table?

    hi,
    how can i lookup a number to 10rows by 10columns (total 100 cells) of data?

    Cell A1
    1234

    Cell B1 to Cell K10 are filled with random 4-digit numbers, and L1-L10 are text to be displayed when a match is found.

    want to see if the number at A1 matches any in the B1-K10 table, then display the text on Column L.
    the B1-K10 cannot be sorted bcoz they are random and changes overtime.

    was experimenting with vlookup & hlookup but couldn't make it.

    iF it has a match, let's say formula on cell A2 then A2 will just display "Match" or "Invalid" etc based on the text input in L1 to L10

    suggestions welcome.
    thanks,
    Last edited by foxxkat; 05-10-2005 at 05:55 AM.

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