Results 1 to 4 of 4

data validation using offset or index match

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2008
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    242

    data validation using offset or index match

    Hi,
    I want to do a data validation in cell A1,where selecting any of the cell options the data would change as per source file,I have tried with index match but without success.The sequence of data will be
    Selecting KOLwould give me below data -
    kol.jpgtable C3-o5
    Selecting WB would show me this data
    wb.jpgc6-o8
    Attached Files Attached Files
    Last edited by arnab0711; 01-24-2012 at 06:46 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