PDA

View Full Version : Excel formula help.



15-03-2002, 05:49 PM
Need a Formula that will search the complete column on another page to match existing number,if it finds a match it should read the data on Bcolumn and write the primary page. The primarypage will have many less matchs of second page which would have inventory data in the B column.

16-03-2002, 01:00 PM
Richard

Is the other page sorted in order? Can this be done with VLOOKUP or am I way off the mark.

Let me know whether you a) know what you are doing and I am teaching your grandma to suck eggs, or b) you've never used it before and would like some tips.

I won't be offended, either way.

robo.