Thread: if cell value matches then copy another cell
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
DataCollector[_9_] DataCollector[_9_] is offline
external usenet poster
  
Posts: 1
Default if cell value matches then copy another cell

Hi,

Sorry you're having so many problems. VLOOKUP won't work if you can'
sort the data.
I use it all the time for spreadsheets with 50,000 rows, so give it
try when sorting the data is an option.

DataCollecto

--
DataCollecto
-----------------------------------------------------------------------
DataCollector's Profile: http://www.hightechtalks.com/m36
View this thread: http://www.hightechtalks.com/t229516

Reply With QuoteReply With Quote