Need formula to lookup data in row
Ron,
Thank you sooooo much! ...
I would never have come up with that myself...
Aloha! ...
dave...
?B?Um9uIENvZGVycmU=?=
wrote in :
Try something like this:
D2:
=IF(COUNTIF(F2:N2,B2+1),INDEX(F2:N2,1,MATCH(B2+1,F 2:N2,0)-4)/A2,"no
match")
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
|