View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Lookup with AND i think

All sorted - {=LOOKUP(I2,IF($A$1:$A$5000=H2,$B$1:$B$5000,""),$C $1:$C$5000)}

Thanks


Jarek Kujawa wrote:


Hi jarek - Please may i have your email address.
Many Thanks

[quoted text clipped - 29 lines]

- Pokaż cytowany tekst -


--
Matt Lynn

Message posted via http://www.officekb.com