Thread: Lookup or IF?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eucalypta Eucalypta is offline
external usenet poster
 
Posts: 29
Default Lookup or IF?

Dear all,
Looking for your kind help on the below:

In a spreadsheet I have the following cols and rows:
Col B Col E Col F Col G Col L Col Q
Date Artnr Pcs Price Order# Formula
(=IF(AND(B5<NOW()-60;L5="");"Alarm!!!";""))

What I am looking for is the following:
if Alarm is true I would like Excel to show me the art#, pcs and price in a
separate worksheet. Should I use IF or Lookup?
Thanking you in advance,
KG, Eucalypta