Thread: Newbie Question - vlookup, I think
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Soniya[_4_] Soniya[_4_] is offline
external usenet poster
  
Posts: 73
Default Newbie Question - vlookup, I think
in C1 for your First column try this:
=IF(AND(A1="Remote",B15,B1<10),"X","")

then modify for other cells accordingly

Thanks

Reply With QuoteReply With Quote