View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nidabland nidabland is offline
external usenet poster
 
Posts: 8
Default IF function using two worksheets and various data

I have one worksheet that has stock numbers in one row and account numbers in
one column. On my other worksheet, I have account and stock and prices in
separate columns. I want to populate my first worksheet with the prices that
are on my second worksheet without having to retype in all the data. It is
over 200 different stocks and will take a lot of time. Thank you for any
help.