Did you remember to "array-enter" the formula ie to press CTRL+SHIFT+ENTER
[CSE] to confirm the formula (instead of just pressing ENTER)??
If you did the above confirmation correctly, you should see Excel wrap curly
braces: { } around the formula in the formula bar. If you don't see it,
click inside the formula bar and try the CSE again.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"insitedge" wrote
First, thanks. I could not have conceived that formula. But when I
entered it, I receive an #NA. When I remove the values (vendor name
and item name) from cells D3 and E3, leaving those cells blank, the
#NA disspaeras indicating that if those cells are blank nothing will
be displayed, but I don;t understand why I am receiving an #NA.
Any thoughts?