Steven wrote:
How do you do a vlookup and hlookup at the same time:

D E F
A 1 4 7
B 2 5 8
C 3 6 9

Where for example A E = 4

Thank you for your help.

Steven

Highlight your data range, including the headings; click on
Insert|Name|Create; check Top row and Left Column, OK. Then
=A D will return 4, =B D will return 2, etc.

Alan Beban