Thread: Need help scanning a column and getting a return value.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Need help scanning a column and getting a return value.
One other guess
In C1: =IF(A1=2,B1,"")
Copy down to last row of data in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Mike" wrote:
Disregard the visual example of the columns, i should have checked before
hand for alignment.

mike
Reply With QuoteReply With Quote