thank you Suresh but why change the complete Client list???? And why the drop down Menu ? the drop down menu deosnt work as why add it this is not what i asked for all i wanted was an explanation as to why my formula woudnt work.
can some one please explain as to why i still get the N/A come up when i feel that i have entered the correct paramters for this formula.
the lookup is in D8 for the phone number
https://docs.google.com/file/d/0B_IZpMAnctBDRV8yWjdaajhTaXM/edit?usp=sharing
thank you in advance
Peter From...