98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL
EXCEL
Resolved · Urgent Priority · Version 2003
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.
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 stephenATstl-training.co.uk , with s description of what you are trying to achieve.
I will the give it my urgent attention
Regards
Stephen
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 tip:Number format shortcutCtrl+Shift+! applies the Number format, with two decimal places |