+ Reply to Thread
Results 1 to 4 of 4

How to get cell data based on row and column values

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    bangalore
    MS-Off Ver
    2010
    Posts
    2

    How to get cell data based on row and column values

    Hi,

    I need to get the value high lighted in yellow in attachment based on row value i.e 'mumbai' and column value i.e 'col3'. I can use vlookup but in my case i have 100 columns are there so i can't count index number. so please give me any formula to search based on row value and column value combined.Test123.xlsx

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: How to get cell data based on row and column values

    Using your posted workbook...here's one approach:

    On Sheet2
    A1: a city to find.....Mumbai
    A2: a column reference to find....Col3

    This formula returns the value at the intersection of the row containing that city and the column containing that column reference
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    05-26-2015
    Location
    bangalore
    MS-Off Ver
    2010
    Posts
    2

    Re: How to get cell data based on row and column values

    Thank you very much its working as i need

  4. #4
    Registered User
    Join Date
    09-16-2015
    Location
    wroclaw
    MS-Off Ver
    2013
    Posts
    1

    Re: How to get cell data based on row and column values

    very nice, thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 09-07-2014, 05:42 PM
  2. Replies: 3
    Last Post: 03-22-2014, 08:35 AM
  3. Merge values from column in one cell, based on duplicates in another column
    By Rawland_Hustle in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-24-2014, 11:04 AM
  4. Replies: 2
    Last Post: 03-12-2013, 04:10 PM
  5. Replies: 8
    Last Post: 02-16-2011, 05:03 PM

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