Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
EXCEL
Resolved · Urgent Priority · Version 2003
Reply Fri 3 Oct 2008, 15:17Delegate Thomas said...
Thomas has attended:
Excel Intermediate course
Excel Advanced course
EXCEL
Hi guys,
I need a formula which returns the value at the intersection of a vlookup and an hlookup in a different workbook.
Effectively I have values 1 and 2 in one worksheet, I have those same values in table on another worksheet. 1 is at the head of a column, 2 is the leftmost value in a row. I need a formula which gives me the value at the intersection of that value and that row, and I need it to be generalisable to any two values that head a row or column in that table.
I tried: Index(table,row(vlookup(2,table,1,0)),column(hlookup(1,table,1,0)) but it didn't work, I don't know if you can get the column reference of a a lookup in a different sheet.
For upcoming training course dates see: Pricing & availability
RE: EXCEL
Hi Michael
Thank you for your question
It is difficult to advise you without seeing the workbook in question. Could you email a copy to me at stephenATmicrosofttraining.net , with s description of what you are trying to achieve.
I will the give it my urgent attention
Regards
Stephen
|