INDIRECT.EXT FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This formula:

=INDIRECT.EXT('H:\["&D100&".xls]BUYERSREQUEST'!C44)

keeps giving me a #value error...any obvious reasons....
 
Kaby

The indirect function requires the other workbook to be open. You might be
better creating links between the books. If you can open both books together
enter = then point to C44 on the buyersrequest sheet and press enter.

Regards
Peter
 
Back
Top