View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bport jim bport jim is offline
external usenet poster
 
Posts: 1
Default array formula with if and hlookup

trying to make an array formula to look in row 2 for "4" and return from row
3, if row 1 = "1" looking for the answer "d"
row1: 1 1 2 1 1
row2: 7 5 4 4 6
row3: A B C D E
trying {=IF(A1:E5=1,HLOOKUP(4,A2:E5,2,FALSE)," ")}
hoping someone smarter than me can help
bport jim