Re: $$Excel-Macros$$ VLOOKUP function

2010-10-11 Thread Pranav Vashishtha
Dear Alan Apply tis formula and your problem will be over. VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are correct but in the 3rd parameter (Column no.) you supplied the column address that is $E:$E. I have just changed it to column no. 2 which is second column of your table w

Re: $$Excel-Macros$$ VLOOKUP function

2010-10-11 Thread Pranav Vashishtha
Dear Alan Apply tis formula and your problem will be over. VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are correct but in the 3rd parameter (Column no.) you supplied the column address that is $E:$E. I have just changed it to column no. 2 which is second column of your table w