Combing Lookup Horizontally and Vertically

**kimberlyre2000** · 11-30-2012, 05:23 PM

Please help me understand the formula for the follows:

Lookup result using both Column Header and Row (attachment included).

Thank you.

**kbkumar** · 11-30-2012, 05:33 PM

Hi Kimberlyre,

You need to provide more background to the problem. What are you trying to lookup (am assuming it would be ID's) and from where (source)? What is your desired output etc.

Thanks.

**kbkumar** · 11-30-2012, 05:34 PM

duplicate post

**kimberlyre2000** · 11-30-2012, 06:48 PM

I have a source document (huge file)....

I am only interested in a few of the ID's and a few of the Column information. The source document has hundred's of ID, along with 50 different column types.

Therefore, I want to be able to say based on this "ID", please return the Identified Column information.

I hope this helps.

**FDibbins** · 11-30-2012, 06:55 PM

you need to use index/match, not vlookup/hlookup

something like...

=index(range-including-headings,match(row-ID,row-ID-range,0),match(heading-name,heading-name-range,0))