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
|