View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Lookup with AND i think

excellent

On 6 Lis, 14:55, "Mattlynn via OfficeKB.com" <u44078@uwe wrote:
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 viahttp://www.officekb.com