Just replace the static value the Wizard inserts into the formula with the
appropriate cell references.

=INDEX(Source!$A$1:$Z$58000, MATCH("1234567",Source!$A$1:$A$58000,),
MATCH("Name",Source!$A$1:$Z$1,))

becomes

=INDEX(Source!$A$1:$Z$58000, MATCH($A2,Source!$A$1:$A$58000,),
MATCH(B$1,Source!$A$1:$Z$1,))



AlfNeuman wrote:
The Wizard apparently only works with a single worksheet or spreadsheet file.
I couldn't select one set of data from the daily sales worksheet and use that
info to lookup the corresponding data in the master spreadsheet / worksheet.


"Glenn" wrote:
What do you mean "the wizard didn't like that"? Describe exactly the results
you got.




AlfNeuman wrote:
I tried the Lookup Wizard to find information contained in one worksheet of
58,125 rows. I first tried with my source criteria in one worksheet of 147
rows and the info I needed in the bigger worksheet. The wizard didn't like
that.