excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL

EXCEL

resolvedResolved · 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


 

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips


Server loaded in 0.09 secs.