I altered my formula as recommended and the formula was deleted from the cell
(E4) and therefore defeats its purpose. I want the formula to remain but not
display #N/A if D4 is blank.
Thanks
=IF(D4="","",(INDEX('C:\Users\Laptop 2\Desktop\[Donor List.xlsx]Donor Master
list-08'!$B$1:$F$426, MATCH(D6,'C:\Users\Laptop 2\Desktop\[Donor
List.xlsx]Donor Master list-08'!$B$1:$B$426,), MATCH("Sale
Price",'C:\Users\Laptop 2\Desktop\[Donor List.xlsx]Donor Master
list-08'!$B$1:$F$1,))))