I use VLOOKUP and HLOOKUP all the time. Is there a function that combines both?
I'd like to set up a data array and read from it using the row heading and column names. So eg read the data from the column called "Car" at the row called "Blue". I see there is an index function but unless I'm reading it wrong that seems to deal solely with column & row numbers, not names.
Last edited by AndyGW; 12-04-2012 at 10:09 AM.
use index / match for that.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Could you to elaborate a little? Would you mind pasting an example line of code so I can see the syntax?
many thanks
there are many examples online. http://www.randomwok.com/excel/how-to-use-index-match/
You will find a detailed article about Index/Match here.
Taming the Excel dragon... www.TheExcelphile.com
Thanks, everyone. +rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks