View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Davey Boy Davey Boy is offline
external usenet poster
 
Posts: 2
Default 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